Snowflake connection to Semantic Model in Powerbi

[julsr]

Hello Everyone,

I have my semantic models connected to SQL Server, but now I have migrated everything to Snowflake, and I would like to know the best practices or recommendations for:

- Get information from Snowflake to my Semantic models

- Auto-refresh the semantic models in PowerBI with the latest data from Snowflake

- Monitor the changes between each semantic model version

Thanks, everyone, for any recommendations!

[hackcrr · Accepted solution]

Hi, @julsr 

Get information from Snowflake to my Semantic models, You can refer to the following article, which suggests you use the official linker:

https://www.snowflake.com/blog/maximizing-power-bi-with-snowflake/

https://www.snowflake.com/wp-content/uploads/2021/10/Best-Practices-for-Optimizing-Your-dbt-and-Snow...

 Auto-refresh the semantic models in PowerBI with the latest data from Snowflake:

Set up a scheduled refresh in Power BI to automatically update your semantic models with the latest data from Snowflake.

Monitor the changes between each semantic model version：

Implement version control for your semantic models. Tools like Git or Azure DevOps can help track changes over time. Consider using third-party version control tools, such as Git, to manage and track changes to your semantic models more effectively.

Best Regards,

hackcrr

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.