Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

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.

MuqadderIqbal

PowerBI service fails to refresh an API data source, PBI desktop has no such issue

Submitted by on ‎05-22-2017 02:19 PM

PBISvcRefreshFailure.JPG

 

 

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?

Status: New
See more ideas labeled with:
1 Comment (1 New)
Comments
v-qiuyu-msft
Community Support
Community Support
‎05-23-2017 06:52 PM

Hi @MuqadderIqbal,

 

Based on my test, use the web data source with URL: https://data.seattle.gov/resource/grwu-wqtk.json?$where= datetime > '2017-05-22' can be refreshed after publish the report to service. You can just use that URL to create a report then publish to service and refresh, see if the issue related to dynamic generated current date in WHERE clause.

 

Best Regards,
Qiuyun Yu

Idea Statuses