Forum Discussion

insafM's avatar
insafM
Frequent Visitor
2 years ago
Solved

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

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 not...
Need Help
  • GilbertQ's avatar
    GilbertQ
    1 year ago

    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's avatar
GilbertQ
Super User
1 year ago

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's avatar
insafM
Frequent Visitor
1 year ago

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 ?