topic Re: Change SQL database credentials in Power BI deployment pipeline in Developer

Change SQL database credentials in Power BI deployment pipeline

Johonnatan — Wed, 12 Jun 2024 19:38:48 GMT

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.

Re: Change SQL database credentials in Power BI deployment pipeline

Anonymous — Thu, 13 Jun 2024 07:50:26 GMT

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 | Microsoft Learn

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.

Re: Change SQL database credentials in Power BI deployment pipeline

Johonnatan — Thu, 13 Jun 2024 12:37:42 GMT

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