Forum Discussion
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 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.
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.
2 Replies
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.
