Incremental refresh for larger datasets

Hi Rockz ,
Thanks for reaching out to the Microsoft fabric community forum.

It's possible that model refresh queries aren't being folded, leading to excessive refresh times and query mashup engine resource utilization. Use a tracing tool at the data source to confirm that each partitioned query includes filters based on RangeStart and RangeEnd. If not, check for query folding in Power BI Desktop by loading a small, filtered dataset. If folding isn't occurring, adjust the model to support it. Then, either perform a metadata-only update via XMLA (for Premium) or delete and republish the model (for Pro), and try the initial refresh again.
Troubleshoot incremental refresh and real-time data - Power BI | Microsoft Learn


Another possible cause might be the timeout is caused by the amount of data that must be queried and loaded into the model partitions exceeds the time limits imposed by the capacity. Reduce the size or complexity of your model, or consider breaking the model into smaller pieces.
Troubleshoot incremental refresh and real-time data - Power BI | Microsoft Learn

Additionally, For models published to Premium capacities, if the model grows beyond 1 GB or more, you can improve refresh operation performance and ensure the model doesn't max out size limits by enabling Large model storage format before performing the first refresh operation in the service.

If you find this post helpful, please mark it as an "Accept as Solution" and consider giving a KUDOS. Feel free to reach out if you need further assistance.
Thanks and Regards