Incremental refresh failure

[Anonymous]

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

[v-yingjl]

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.

[Greg_Deckler · Accepted solution]

@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]

Thanks!!