cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
vmakhija Member
Member

Re: Power Bi Service Refresh - timeout expiration issue

@GilbertQ 

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

Super User
Super User

Re: Power Bi Service Refresh - timeout expiration issue

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.


Did I answer your question? Mark my post as a solution!

"Proud to be a Datanaut!"
vmakhija Member
Member

Re: Power Bi Service Refresh - timeout expiration issue

@GilbertQ 

I am in process of configuring Incremental for my report.

But my concern is - how will the first full refresh work considering my dataset takes 5+ hours for the full refresh?

 

Regards

 

 

Super User
Super User

Re: Power Bi Service Refresh - timeout expiration issue

Hi there

What if you had to initially change your incremental refresh to not go back with all your data, but a smaller dataset to see if that would help?


Did I answer your question? Mark my post as a solution!

"Proud to be a Datanaut!"
Highlighted
vmakhija Member
Member

Re: Power Bi Service Refresh - timeout expiration issue

@GilbertQ 

I can try with smaller dataset by using only few months of data.

But once I use all the months again, my dataset refresh time will increase and it will hit the timeout issue again.

 

Regards

Super User
Super User

Re: Power Bi Service Refresh - timeout expiration issue

Hi there

That would indicate that due to the data size something is causing an issue.

Have you had a look at the Power BI Premium Capacity App to see if you run out of allocated memory during the dataset refresh?


Did I answer your question? Mark my post as a solution!

"Proud to be a Datanaut!"
Mohan_Babu Regular Visitor
Regular Visitor

Re: Power Bi Service Refresh - timeout expiration issue

Hi All, 

 

I am experiencing this time out issue now.  its a import dataset and i dont see any duration parameter coded in the advance editor.  do we need to add it to the code.  also this issue is occuring suddenly. 

Super User
Super User

Re: Power Bi Service Refresh - timeout expiration issue

Hi there

what do you mean by the duration parameter?


Did I answer your question? Mark my post as a solution!

"Proud to be a Datanaut!"
Mohan_Babu Regular Visitor
Regular Visitor

Re: Power Bi Service Refresh - timeout expiration issue

@GilbertQ,

 

I mean the time out parameter that you set while connecting to any source.   You can see that in advance editor M code. 

 

 [Timeout=#duration(0, 0, 5, 0)])

 

vmakhija Member
Member

Re: Power Bi Service Refresh - timeout expiration issue

I guess the timeout parameter can only be set if using SQL Server. But not sure if that will override the 5 hours timeout which is present on Power BI Service for any individual running query. Regards