Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi everyone,
I am having a wierd issue in PBI Cloud with one of our PBIX reports where I cannot set up the refresh schedule if I choose to append one of the queries within my PBIX.
My PBIX loads data from two sources, CSV file (Local) and a web page data (Web) (http://api.aip.com.au/public/api?call=tgpTables). I've establish both of these as gateway entries wtihin PBI Cloud. WebJSON ans Local are names of the queries with PBIX, that loads data from the web source and local CSV source, respectively. If I choose not to append these two queries, I am able to set this report to refresh automatically. But, if I choose to append them, Gateway goes crazy and the bit within Gateway connection, the wheels keep spinning looking for the gateway.
Any idea what's going on here?
Thanks
Kaz
@Anonymous It sounds like you are trying to merge online and local in an (Enterprise) gateway. This doesn't work currently. You can't use online and on-premises in the same connection. Now, it sounds like you don't have issues with them in the same report until you append them... which is new to me. I would have thought it would fail regardless, if I understand your question correctly.
That's confusing me as well. I would have expected it to not to work at all. But it's just the appending bit that pushes PBI Gateway over the edge.