Incremental Refresh Timeout Issue with Large Dataset

Hi AshokAinala,

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:

Configure incremental refresh and real-time data for Power BI semantic models - Power BI | Microsoft Learn

Advanced Incremental Refresh and Real-Time Data With the XMLA Endpoint in Power BI - Power BI | Microsoft Learn

Thanks and regards,

Anjan Kumar Chippa