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 sourc...
Need Help
_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.

    • niku_dodiya's avatar
      niku_dodiya
      Frequent Visitor
      5 years ago

      it is cloud only, I am able to create simple report from connecting this database and can refresh as per requirement