Incremental refresh query's taking more 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]

Hi @Narukkp,

Where are you host the data gateway? Did your gateway and data source deploy on the devices with stable network status and nearly locations?

It may reduce the performance if you host them in different environments and link with the proxy or other mapping settings. (e.g. pending to sending/receive the requests, network delay...)
Regards,

Xiaoxin Sheng

[lbendlin]

Couple things to keep in mind

- whenever you do structural changes to your report/dataset this will cause a reset of the incrmental refresh (ie it will initiate a full refresh first, and then on the second scheduled refresh it will go back to incremental).  Try to do these sparingly.

- Incremental refresh is based on distributing data across partitions.  In addition to refreshing the data, the Power BI service will also reswizzle the partitions as needed.  This can add to the processing overhead.