Power BI Service Refresh Failing

[William__K]

Hi all,

Up until Monday, my Power BI Dataset would update without an issue as a scheduled refresh. It usually takes 80-90 minutes. However, the last 5 days have seen this error Data source error: The XML for Analysis request timed out before it was completed. Timeout value: 7200 sec.

What is odd though is that the time it takes it attempt its refresh range from 3 and a half hours to 6 hours in these last few days. When I look at the SQL database usage, it is in full usage for 80-90 minutes and then the usage drops to 0% for a couple of minutes before going back to full usage. It appears to be restarting and because there are other datasets that are refreshing after, resources are being shared which eventually leads to the timeout.

I have had to update the dataset on Power BI desktop. But when I publish the dataset, it is somehow still able to complete the refresh on Power BI Service during working hours. Yet it still fails with the overnight refresh. Is there anything that could be causing this?

Thank you for the support in advance.

[Anonymous]

Hi @William__K ,

This issue has been submitted internally. Please be patient to wait for fixing. If there is any news, I will update it here.

Best Regards,

Neeko Tang

If this post  helps, then please consider Accept it as the solution  to help the other members find it more quickly. 

[William__K]

Thank you @Anonymous for the update. Is there perhaps an alternative to a scheduled refresh because it currently runs overnight but is required to be updated before the start of the working day. I have been refreshing it on desktop at the moment but that is a manual process.

Regards,
William

[William__K]

Hi @Anonymous,

Is there an update on this? It's not feasible to continue refreshing it on desktop manually and finish the update before other people start work in the morning. I have rebuilt the dataset and made it a lot simpler with calculated columns and power qeury statements, and it had been refreshing normally, but it faced the same issue this morning where it loaded the data in and then restarted the refresh.

Regards,

William

[Anonymous]

Hi @William__K ,

I want to acknowledge valuable input provided by lbendlin. I have some other thoughts to add:
Have you tried clearing the credentials to republish to the Power BI service and then refreshing it again and does it resolve the issue?

Best Regards,

Neeko Tang

If this post  helps, then please consider Accept it as the solution  to help the other members find it more quickly. 

[William__K]

Hi @Anonymous,

What permissions do you mean? 

Generally, I have cleared the cache on the report. I have deleted a lot of calculated columns that could have been causing an issue post download, as well as some applied steps. The refresh still restarts on Power BI Service but is fine on desktop. I am not too sure what else to do.

[Anonymous]

Hi @William__K ,

Sorry, I meant to try to reset the semantic model credentials. Does it solve the refresh timeout issue? If not please let me know.

Best Regards,

Neeko Tang

If this post  helps, then please consider Accept it as the solution  to help the other members find it more quickly. 

[William__K]

Hi @Anonymous,

Thanks for your help so far. I reset the credentials for the SQL database that we use, but that didn't work unfortunately. It still downloads all of the data and then restarts the refresh soon after.

[lbendlin]

If you have a Pro license you can open a Pro ticket at https://admin.powerplatform.microsoft.com/newsupportticket/powerbi
Otherwise you can raise an issue at https://community.fabric.microsoft.com/t5/Issues/idb-p/Issues .

[William__K]

Thank you for the reply @lbendlin.

I do have a pro licence, but I am not able to submit a ticket at the moment becuase it seems to require the Premier Access ID and Contract ID, which I don't have at the moment.