Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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?
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.
@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?
Thanks!!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.