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.
Hi,
I'm trying to recreate what Charles Sterling describes in his blog post here:
...but instead of using Flow, I'm calling the web service from Excel using Power Query. I have the Historic Data Analysis option turned off. The strange thing is that the data in the dataset only seems to be updated about 50% of the time. On my side everything seems to be working ok: the calls to the web service always succeed, and I can see them sending what I expect using Fiddler. I'm also nowhere near the published limits for the API (https://msdn.microsoft.com/en-us/library/dn950053.aspx). It's just that my dashboard tiles don't always change with the new numbers. I can't see a pattern either: sometimes it works, sometimes it doesn't, although it does seem more likely to work after I have not made any other requests for a few minutes. Is there some unpublished limit that I'm running into?
Chris
Have you tried forcing a tile refresh by selecting the ellipse (...) in the upper right of a dashboard and selecting Refresh dashboard tiles? And please wait about 10-15 minutes for refresh to be reflected in the dashboard tiles. If it is still not showing up, re-pin the visualization to the dashboard.
https://powerbi.microsoft.com/en-us/documentation/powerbi-refresh-troubleshooting-refresh-scenarios/
Thanks Sam, I've tried all those things and none of them work. I'll double-check and see whether the calls are failing on my side for some mysterious reason, but apart from that I'm stumped.
Chris
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
12 | |
2 | |
1 | |
1 | |
1 |