Forum Discussion

adeelnazir's avatar
adeelnazir
Icon for Helper I rankHelper I
5 years ago

Power BI Incremental Refresh taking more time than normal refresh

I've applied Incremental refresh on multiple tables having a complex model. I've been followed all steps guides available in the documentation. Link Below highlighted is showing incremental refresh...
Need Help
Show and Tell
Tips and Tricks
adeelnazir's avatar
adeelnazir
Icon for Helper I rankHelper I
5 years ago

Ok, I got your point. So let say if I go with SQL profiler and see what queries are sending back and forth.

Then my question will be what I need to see If I see any discrepancy?

Let say if all working fine, Power BI will store the max date then try to find if there any date exists greater than stored, then load all data. 
What are the possible points that I need to fix/check on incremental refresh?

 

GilbertQ's avatar
GilbertQ
Icon for Super User rankSuper User
5 years ago

Hi adeelnazir 

 

It would be the SQL profiler really is your best bet if connecting to a SQL Server database.


With regards to v-kkf-msft  I am pretty confident that performance analyzer will not be able to track your incremental refreshing. It will work for DirectQuery queries but not the refreshing of the dataset.