Forum Discussion
Incremental Refresh Timeout Issue with Large Dataset
Hi Anonymous,
Thank you for reaching out to Microsoft Fabric Community.
Thank you for the details. Here since the RangeStart and RangeEnd parameters are configured correctly, looks like the issue is due to the initial refresh, which needs to load all 10 million records. This is likely exceeding the available resources and causing the error
- Please verify the query folding is working for the RangeStart and RangeEnd filters, as the incremental refresh relies on query folding for efficient data loading. If query folding is working and the issue still occurs, this is likely a capacity or resource limitation. In that case, please use a Premium/Fabric capacity with an XMLA endpoint bootstrap refresh for the initial load.
For your reference, please follow below documentation:
Thanks and regards,
Anjan Kumar Chippa
Community SupportHi Anonymous,
As we haven’t heard back from you, we wanted to kindly follow up to check if the solution I have provided for the issue worked? or let us know if you need any further assistance.
Thanks and regards,
Anjan Kumar Chippa
Community SupportHi @AshokAinala,
We wanted to kindly follow up to check if the solution I have provided for the issue worked? or let us know if you need any further assistance.
Thanks and regards,
Anjan Kumar Chippa