Forum Discussion
Dataset Refresh fluctuations
I got my Trace back from the last 3 hour refresh, pretty wild result:
The tables causing the slow down were simple few hundred row Excel file connections (Web Connector using sharepoint link location).
These Excel tables take around 20 Seconds typically in Service (and even less Locally), and are now taking upwards of 60-90 Minutes each!
Every other table (nearly all Dataflows) returned in a normal amount of time.
Hi cassidy
Yeah sometimes what happens is that there might be challenges and issues in the background which we are not aware of. I would suggest seeing if it is still like this in a few days time?
Hopefully it should resolve itself. I have seen things auto resolve in the past!
The refreshes walked themselves back down from 3 hours to 1 hour without me doing anything
To your point, sometimes these things "fix" themselves. It's one of the unfortunate sides of Power BI in that the Admin side is very "light", so much is being done that cannot be seen. I don't doubt there was an important reason my Dataset tripled in refresh time...but why? How am I supposed to explain these instances to our Users?
Not expecting an answer, just calling it out
