Enhanced API incremental refresh takes way less than on-demand incremental refresh

[insafM]

Dear Community , 

I hope you can help me solve this.

We have established Semantic model refresh via web activity from azure datafactory to run incremental refresh ( policy already defined).

We noticed that the refresh from the ADF pipeline takes way less than on-demand (3s Vs 9 min) 

Both refreshes happened the same day and there were no change of data in the source:

Does anyone have an idea why is this happening  

[GilbertQ · Accepted solution]

Hi @insafM 

You can log in with SQL Server Management Studio and then right click on the table and select Partitions to view when it was last processed?

[GilbertQ]

Hi @insafM 

There are multiple things that could potentially cause this to happen. One of the things could be when you are refreshing by the web activity, it is only refreshing a subset of the data.

[insafM]

Hi @GilbertQ , 

thank you so much for answering my question.

in the web activity we have set the body as to apply incremental refresh policy so I am expecting it to refresh the Delta but how do I know if it is only refreshing a subset of the data ?