My agency is using Power BI internally for visualisations and Snowflake as our data lakehouse. We are interested in publishing some basic dashboards on our website, starting with high level summary data and possibly some profiles for entities with basic data. Has anyone done this using Power BI and Snowflake?

That's a fairly trivial implementation to do. There is a Publish to Web functionality that you can use to embed those Power BI reports within the website. Just beware that Publishing to the Web will make it so anyone can access that report and that data.

Yes, done this for some of our clients. Not sure if you're fixed on Power BI and the scope of use. We're considering moving to Sigma, they work tightly with Snowflake; faster insights and scalable. AI features allow self-service queries which are more dynamic than static dashboards.