Forum Discussion

Gianf's avatar
Gianf
Advocate 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...
  • 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)])