Change SQL database credentials in Power BI deployment pipeline

[Johonnatan]

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.

[Anonymous · Accepted solution]

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:

Create deployment rules for Fabric's Application lifecycle management (ALM) - Microsoft Fabric | Mic...

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.

[Johonnatan]

Sorry @Anonymous if it's a beginner question, but how pass data source credentials as parameters?