Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
sandraCortes
Helper I
Helper I

Dynamically Change password connection in data models for snowflake

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.

 

8 REPLIES 8
sandraCortes
Helper I
Helper I

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.

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.

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.

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

Are your connections pipelines or Kusto?

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

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

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

Top Solution Authors