Trigger a semantic model refresh when Snowflake table is modified

[JChohan]

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 it could be once a day however on another day it could be 5 times a day, If I add a PBI scheduled refresh for example for 8 times a day that could be an overkill.

My question is it possible that PBI would check Snowflake table every hour if table has new data - if yes then refresh semantic model - if no then ignore/do not refresh semantic model. Thanks guys.

[GilbertQ · Accepted solution]

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.