if(trackingNum != 'null'){ } Would anybody know a simple way of integrating Zephyr into PowerBi? Bare in mind there is an Api called ZAPI(Zephyr API)