Forum Discussion
Change SQL database credentials in Power BI deployment pipeline
Hey folks.
I have added a Power BI deployment pipeline for my projects that contains 3 different workspaces (dev, test, prod), however, my challenge is figure out a solution to change database credentials in each pipe. For security reasons, dba team created distinct user/pwd for on each database. I know that we can change data sources through deployment step but I am not sure if there is an option to push in credentials too.
Well thanks for any help.
Hi Johonnatan ,
According to your needs, you have different database connection attributes and credentials provided for different pipeline phases, so you can refer to this official document to create a deployment rule, to do the definition of the rules of the different phases and parameter logic settings, and check if it helps:
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 Replies
Hi Johonnatan ,
According to your needs, you have different database connection attributes and credentials provided for different pipeline phases, so you can refer to this official document to create a deployment rule, to do the definition of the rules of the different phases and parameter logic settings, and check if it helps:
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Sorry Anonymous if it's a beginner question, but how pass data source credentials as parameters?
