Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello everyone,
I am currently prototyping a PowerBI report that consumes a piblicly available API as the only data source. When I open and refresh the PBIX report in PBI desktop, it refreshes fine. I then publish the report to PBI service and I can see the Last Refresh Date/Time correctly. However, when I try to refresh the Dataset from PBI Service, it immediately fails with an exception. See attached.
The API query URL from PowerQuery is https://data.seattle.gov/resource/grwu-wqtk.json?$where= datetime > '2017-05-22'. Just that the WHERE clause is dynamically generated for current date within PowerQuery in a prior step.
Any ideas why this could be?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.