Forum Discussion
Dataset Refresh fluctuations
Looking for insights into the reasons a Dataset Refresh runtime could fluctuate signficantly in Service A few facts: No published changes to the Dataset during the period Capacity has remained...
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.