Forum Discussion

niku_dodiya's avatar
niku_dodiya
Frequent Visitor
5 years ago

Incremental refresh is failing

Incremental refresh is not working. I have data in sql server. All the step mentioned for incremental refresh I have followed.

simple refresh is working. Power BI desktop is also fine

 

Data source error: {"error":{"code":"ModelRefresh_ShortMessage_ProcessingError","pbi.error":{"code":"ModelRefresh_ShortMessage_ProcessingError","parameters":{},"details":[{"code":"Message","detail":{"type":1,"value":"Microsoft SQL: Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding."}}],"exceptionCulprit":1}}}

Need Help

8 Replies

  • _sfrost's avatar
    _sfrost
    Icon for Solution Specialist rankSolution Specialist
    5 years ago

    Check if you can access the source from the Gateway machine? Ping the server name or IP Address or connect to source from Power BI Desktop.

     

    If it's working fine in desktop and having issue only in Service, it could be something to do with Gateway.

    • niku_dodiya's avatar
      niku_dodiya
      Frequent Visitor
      5 years ago

      it is working fine in desktop.

      I am not using gateway, I am connecting sql server.

      Data source error: {"error":{"code":"ModelRefresh_ShortMessage_ProcessingError","pbi.error":{"code":"ModelRefresh_ShortMessage_ProcessingError","parameters":{},"details":[{"code":"Message","detail":{"type":1,"value":"Microsoft SQL: Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding."}}],"exceptionCulprit":1}}}

      • _sfrost's avatar
        _sfrost
        Icon for Solution Specialist rankSolution Specialist
        5 years ago

        niku_dodiya 

        When you say you are not using gateway, you mean you are connecting to Azure SQL Server or is it On-premises SQL Server?

         

        Looking at the error message, it's clear that Power BI couldn't get any response from the source. So, I would first check with the DB connection in either case.

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi  niku_dodiya  ,

     

    This was because on the first refresh it has to process all the data before it can incrementally refresh the dataset.

    As per the documentation the default timeout for a SQL Server database is set to 10 minutes, and when I am processing a lot of data it can easily take longer than 10 minutes to return all the data.

    To allow the dataset to run for longer, as per the documentation above I can specify the CommandTimeout optional parameter.

     

    For specific operations, you can check this document:

    https://www.fourmoo.com/2020/02/26/ensuring-your-power-bi-incremental-refresh-does-not-timeout-when-using-a-sql-server-source/

    https://www.nabler.com/articles/power-bi-data-refresh-and-scheduling-3/

     

    Best Regards,

    Liu Yang

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