Forum Discussion
Power Bi Service Refresh - timeout expiration issue
Hi PBI Team, We are facing an issue in power bi service as well as in desktop app. We have huge amount of data available in tables (>10GB). We are importing data using SQL Server database. Previo...
I am looking for some help here based on some issues I have been facing.
My dataset refresh fails once it goes beyond 5 hours. So does this mean that no refresh can run longer than 5 hours in Power BI service? Or does have to do with individual queries in Power BI?
So, hypothetically, lets say I have 50 queries in my dataset and each will run for exact 10 mins which makes it 8+ hours. Will this run fine or will it fail because total time taken is more than 5 hours?
FYI, of course I am talking about premium workspaces as I mentioned 5 hours.
Thanks for your help.
Regards
Hi there
What could possibly be happening is when using Power Premium there could be a lot of factors causing it to fail.
Such as running out of memory, other reports being loaded which could possibly stop the refresh and other things.
What I would suggest doing is to rather see how you can get the refresh time down by using incremental refreshing. That is where I would focus my effort.
When refreshing data there are quite a few moving parts which could affect the refresh failing.
What could possibly be happening is when using Power Premium there could be a lot of factors causing it to fail.
Such as running out of memory, other reports being loaded which could possibly stop the refresh and other things.
What I would suggest doing is to rather see how you can get the refresh time down by using incremental refreshing. That is where I would focus my effort.
When refreshing data there are quite a few moving parts which could affect the refresh failing.