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 mill...
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?

v-yingjl's avatar
v-yingjl
Icon for Community Support rankCommunity 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.