Forum Discussion

JChohan's avatar
JChohan
Frequent Visitor
1 year ago
Solved

Trigger a semantic model refresh when Snowflake table is modified

Hi all, I've a scenario where data is updated multiple times in Snowflake table during a day (2 or more times) and after each data update PowerBI semantic model should be refreshed. One any given day...
Need Help
Show and Tell
  • GilbertQ's avatar
    GilbertQ
    1 year ago

    Hi JChohan 

     

    What you could do is have a control table and Snowflake watchful have the date changed if there has been a update to the Snowflake tables, you could then use power automate to query the snowflake table and when there is a change to then successfully refresh the semantic model.

     

    I have done this for other clients and it works quite well.

GilbertQ's avatar
GilbertQ
Super User
1 year ago

Hi JChohan 

 

What you could do is have a control table and Snowflake watchful have the date changed if there has been a update to the Snowflake tables, you could then use power automate to query the snowflake table and when there is a change to then successfully refresh the semantic model.

 

I have done this for other clients and it works quite well.

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    Hi,
    Please elaborate the steps how you configured. I need to implemt same in my project