Dynamically Change password connection in data models for snowflake

[sandraCortes]

Hello Everyone,

We want to be able to regularly update passwords (password rotation) for improved security (periodically change the password for our service account in Snowflake).

Do you know how we can manage that in Power BI in a way that is much more efficient than manually updating credentials in every report we have?

I appreciate your comments.

[sandraCortes]

Hello Everyone,

We want to be able to regularly update passwords (password rotation) for improved security (periodically change the password for our service account in Snowflake).

Do you know how we can manage that in Power BI in a way that is much more efficient than manually updating credentials in every report we have?

I appreciate your comments.

[d_gosbell]

For things like snowflake you can take advantage of the new Shareable Cloud Connections Connect to cloud data sources in the Power BI service - Power BI | Microsoft Learn to define the connection and credentials once and then use these for multiple reports. Then you can just change the password on the shared connection.

[sandraCortes]

Thank you @d_gosbell , that looks great... however I would have to change the password manually every time in both database and PBI connection.

Do you know if with an API is possible to change the password for the shared connection?

I was thinking about create a development that periodically and automatically changes the password in the database and changes it on the shared conection as well.

Thanks.

[lbendlin]

Datasets - Update Datasources In Group - REST API (Power BI Power BI REST APIs) | Microsoft Learn

[sandraCortes]

Thank you @lbendlin Do you know if exist any API to update a Shareable Cloud Connection? 

[lbendlin]

Are your connections pipelines or Kusto?

[sandraCortes]

@lbendlin thank you for answering. Sorry what is the difference? 

[lbendlin]

sounds like your data source is not compatible. Please refer to the documentation.