Forum Discussion
Timeout error with scheduled refresh
Hello
I am facing an error with scheduled refresh where my dataset refresh times out after running for 5 hours.
Below is an error -
I am using SAP HANA as a data source. I made sure that this is the only refresh running at this time, but still gave an error.
It refreshes fine on Power BI desktop.
Also, refresh for other reports using SAP HANA runs fine for smaller datasets with scheduled refresh, but I do need to make it run for larger datasets too and this issue is preventing me to do that.
Any inputs on this
Regards
4 Replies
The Power BI team is the only ones that can speak Correlation ID. You could check the Issues forum here:
https://community.powerbi.com/t5/Issues/idb-p/Issues
And if it is not there, then you could post it.
If you have Pro account you could try to open a support ticket. If you have a Pro account it is free. Go to https://support.powerbi.com. Scroll down and click "CREATE SUPPORT TICKET".Greg_Deckler thanks
I also checked that the refresh times out after 5 hours with Premium workspace as per this - https://docs.microsoft.com/en-us/power-bi/refresh-troubleshooting-refresh-scenarios#scheduled-refresh-timeout
And in my case it took 5 hours and then this error.
Above article also suggest to consider breaking datasets into smaller pieces. So does this mean if I am pulling data for 1 year together in a single query, I should break it down into lets say 4 queries pulling 3 months each?
My understanding is that the dataset will still be of same size and the cumulative time for refresh will still be same. But will that help?
I mean the max limit of 5 hours is supposed to be cumulative time or something else?
In my workspace, I have seen refresh taking more than 5 hours without failing. Although thats not a normal case for those datasets, it is exceptional that they take 7-8 hours considering there are other refreshes going on too.
I am in bad shape with my refreshes, so trying to understand and explore it better.
Regards
Well, heck, if you have a Premium workspace perhaps you should be leveraging incremental refreshes? I *may* help if you broke your table down into 4 smaller queries with an Append at the end. Power BI can process queries in parallel so as long as your data source can handle the load, this could speed up the data refresh?
