Incremental refresh query's taking double time in power bi service rather than SQL SERVER

[Narukkp]

Hi Team,

I have one report and enabled the incremental refresh feature for 4 objects out of 8 objects. Now problem is power bi service is taking more time to complete the incremental refresh rather than SQL. I have trace the power service incremental query’s from database and executed the same incremental query’s in sql server database and it took the around 7 minutes to complete all query’s but in power bi service it is taking around 15 minutes to complete the incremental refresh.

Now my question is why power bi service taking double time and is there any extra internal mechanism for updates and inserts ,due to this is taking extra time ?

Note : No calculate columns ,measures and transformation in report

[Anonymous · Accepted solution]

Hi @Narukkp ,

Do the tables which configure incremental refresh come from SQL Server database? Please check whether all of these queries support Query folding. If not, the mashup engine compensates and applies the filter locally, which may require retrieving the full dataset from the data source. You can find more details in "Query folding" section of this official documentation.

All You Need to Know About the Incremental Refresh in Power BI: Load Changes Only

Please refer to the content in following blog to check if it can solve your problem.

Power BI Incremental Refresh for SQL Sources

Best Regards