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

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 IV
Super User IV

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 Super User!






Power BI Blog
vmakhija Continued Contributor
Continued Contributor

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 IV
Super User IV

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 Super User!






Power BI Blog
Highlighted
vmakhija Continued Contributor
Continued Contributor

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 IV
Super User IV

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 Super User!






Power BI Blog
Mohan_Babu Helper II
Helper II

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 IV
Super User IV

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 Super User!






Power BI Blog
Mohan_Babu Helper II
Helper II

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 Continued Contributor
Continued Contributor

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

Helpful resources

Announcements
Announcing the New Spanish Forum

Announcing the New Spanish Forum

Do you need help in Spanish? Check out our new Spanish community section.

April 2020 Community Highlights

April 2020 Community Highlights

Info on our Super Users, MBAS content and badges, and updates to our support articles. - Read the full Community Highlights.

MBAS Gallery 2020

MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.