The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event! Join us in Stockholm, Sweden from September 24-27, 2024.
2-for-1 sale on June 20 only!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
Hi,
Can anyone please help me on the below error. Despite my efforts to fine-tune, I continue to encounter a Timeout error when applying incremental refresh. The process functions properly when incremental refresh is disabled; however, the dataset is substantial, containing approximately 80 million records (2.5GB).
Data Source : Shared Folder (XLS files).
Yours suggestions on this matter would be greatly appreciated.
Hi Rathod
It seems like you are indeed hitting the timeout limit for the initial refresh of your data model (the two hour limit that you are observing).
Applying incremental refresh may cause the initial load to be slightly slower than without the policy, hence you seeing a timeout when applying it.
A potential solution is to bootstrap your initial full data load, by publishing a version of the datamodel with a parameter that limits the amount of data. Subsequently you can use Tabular Editor or SSMS to connect to your datamodel via the XMLA endpoint, and from here adjust the parameter, as well as fine tune your incremental refresh partitions: Advanced incremental refresh and real-time data with the XMLA endpoint in Power BI - Power BI | Micr...
_____________________________________________________
I hope my comment was helpful.
If your question was answered, please mark your post as 'Solved' and consider giving me a 'Thumbs Up'.
Find me on LinkedIn, Sessionize, or my blog Downhill Data
Hi Jonvoge,
Thank you for your suggestion, but at the moment, the data source is being retrieved from flat files (Excel files in a shared folder).
Could you please provide your suggestions on this matter?
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
55 | |
42 | |
23 | |
23 | |
16 |