Issue with incremental refresh

[Anonymous]

i have applied incremental refresh on the report an dreport is taking long time to run first refersh(like 5.30 hrs) But normal same report where incremental refresh is not applied is atking only 2 hrs. 

I have checked partitons are happening for incremntal also. So why these incremental report is taking long time.

Please help with these issue.

[Anonymous · Accepted solution]

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.