Forum Discussion
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...
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?
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.