Forum Discussion

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

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?

     

     

3 Replies

  • GilbertQ's avatar
    GilbertQ
    Super User
    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 ?