Forum Discussion
Issue with incremental refresh
Hi Anonymous
First check whether the data source used in your report supports query folding. If the data source used does not support query folding, which may require retrieving the full dataset from the data source. This can cause incremental refresh to be very slow, and the process can run out of resources either in the Power BI service or in the on-premises data gateway if used. Also please check if configure incremental refresh correctly in Power BI.
In addition, please review the content of the following links and check whether you have same situation with them.
Incremental Refresh didn't save time
Power BI Incremental Refresh for SQL Sources
Best Regards,
Community Support Team _ Ailsa Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Anonymous
First check whether the data source used in your report supports query folding. If the data source used does not support query folding, which may require retrieving the full dataset from the data source. This can cause incremental refresh to be very slow, and the process can run out of resources either in the Power BI service or in the on-premises data gateway if used. Also please check if configure incremental refresh correctly in Power BI.
In addition, please review the content of the following links and check whether you have same situation with them.
Incremental Refresh didn't save time
Power BI Incremental Refresh for SQL Sources
Best Regards,
Community Support Team _ Ailsa Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.