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,
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