Forum Discussion

Gianf's avatar
Gianf
Icon for Advocate I rankAdvocate I
1 year ago
Solved

Dataset refresh error - timeout

Hi all,  I am facing this issue: a dataset of mine intermittently timeouts during refresh in service.  The dataset is in a Premium capacity (P1) and it is under incremental refresh.  It is connect...
Need Help
  • v-dineshya's avatar
    v-dineshya
    1 year ago

    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

     

  • Gianf's avatar
    Gianf
    1 year ago

    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)])

     

     





Brianyoung's avatar
Brianyoung
Regular Visitor
1 year ago

The dataset refresh timeout usually happens when the data source takes too long to respond or the query is too complex. To fix this, try optimizing your queries by reducing data volume or simplifying transformations. Also, check if your data source performance is stable and avoid heavy operations during peak hours. If using DirectQuery, consider switching to Import mode for faster refresh. Additionally, verify your Power BI service settings and increase the timeout limit if possible. Splitting large datasets into smaller parts or refreshing incrementally can also help prevent timeouts.