Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Scheduled Refresh Failure

I have 8 dashboards pulling data from different sharepoint sites. Only 2 of them keep failing the scheduled refresh giving the message "The refresh operation failed because it took too long to comple...
Need Help
Shahfaisal's avatar
Shahfaisal
Icon for Solution Sage rankSolution Sage
4 years ago
Anonymous wrote:

Ok thank you, i will try filtering rows and removing redundant or unnecessary columns. Is this based on a file size (the .pbix file is only 5,000 kb). Though, i believe there is over 60,000 rows of data being brought in from one data source.

It is not based on file size. I have a PBIX file that is 3 MB in size but takes over 50 minutes to refresh. The error is directly related to ow long it takes to refresh the data. Note that sometimes (actually often), Power BI Service takes longer to refresh data, particularly for cloud data sources.

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Thank you! Would this be related to how many dashboards are refreshing? I have 8 of them, and some co-workers using the same sharepoint pages have several of their own. Running refreshes either automatically or manually.