Forum Discussion
Advocate IDataset refresh error - timeout
Hi Gianf ,
To address this effectively, we recommend raising a support ticket with Microsoft Azure Support. This will allow the engineering team to investigate the issue in detail and provide a resolution or guidance
To raise a support ticket for Fabric and Power BI, kindly follow the steps outlined in the following guide:
How to create a Fabric and Power BI Support ticket - Power BI | Microsoft Learn
If this post helps, please give us Kudos and consider marking it Accept as solution to assist other members in finding it more easily.
Thank you
Hi v-dineshya
We were able to solve the issue with the help of Microsoft support.
It is somewhat a workaround, but it works, so... here it is the solution.
We added an explicit longer timeout in Power Query connection to SQL Server:Sql.Database(ServerName, DbName,[CommandTimeout=#duration(0,0,45,0)])
Advocate IHI Brianyoung thank for your feedback.
Dataset is in import and incremental refresh. Usually it takes 30 minutes to refresh, but sometimes (well... actually everyday in the past three days, including today) it timeouts after 15 minutes; then at the second try, it works in the usual 30 minutes. Moreover I am in a premium capacity.. timeout is 5 hours.
In the past weeks, until past tuesday included, it refreshed in 30 minutes like a charm.
The query is always the same: how it is possible that sometimes it is too complex and timeouts, whereas in other days it works without troubles? and if the query is so complex that timeouts, why does it succeed on the second try?
DBAs say no jobs/other queries/anything else is running at refresh time. No other datasets are refreshing at the same time.
How can I troubleshoot this?
Thanks to everybody who will point me in the right direction.