Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Incremental refresh failure

Hi All,

I am using Power BI pro and recently, I tried to configure incremental refresh.  My data source is a cloud SQL server database which consists of two years of data containing more than 6 million records. When I do the initial refresh, it took more than two hours and gave a timeout error. I tried this several times and the result was the same.

Thanks

Regards

Udara

Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    6 years ago

    Anonymous - That's kind of surprising, I've ingested that many rows into Power BI Desktop in like 15 minutes. Perhaps you need to bump up the resources on your cloud SQL Server instance? Maybe ingest everything and then setup incremental refresh?

3 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    6 years ago

    Anonymous - That's kind of surprising, I've ingested that many rows into Power BI Desktop in like 15 minutes. Perhaps you need to bump up the resources on your cloud SQL Server instance? Maybe ingest everything and then setup incremental refresh?

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Thanks!!

  • v-yingjl's avatar
    v-yingjl
    Community Support
    6 years ago

    Hi Anonymous ,

    The first refresh may take longer to import the historical data when configuring incremental refresh. 

    If the refresh is timeout, you can try to set the timeout range to check it manually like this in power query

    In addition, you can enable XMLA endpoint to benefit your incremental refresh, refer this document:

    XMLA endpoint benefits for incremental refresh 

     

    Best Regards,
    Yingjie Li

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