Build Configurations

[jdobrzen]

I am trying to design some what of a deployment pipeline/framework for promoting PBIX files from a "dev" environment to a "prod" environment.  I believe using two seperate app workspaces is a start, but what I am struggling with is if there is a way to manage connection properties inside of Power BI Desktop?

I am looking for something similar to build configurations in Analysis Services.

[Anonymous · Accepted solution]

Hi @jdobrzen,

As @Greg_Deckler said, query parameter can used to control connection string, but current this feature not available on power bi service.

Power BI Tutorial: How to Parameterize Connection Variables in Power Query

Pass Parameters to SQL Queries

You can also try to build report as report model, then you can use original model file to create multiple report by change connection string.

Deep Dive into Query Parameters and Power BI Templates

Regards,

Xiaoxin Sheng

[jdobrzen]

I appreciate the links. Thank you!

[Greg_Deckler]

Can you create query parameters to hold your dev versus prod connection settings and then use those parameters in your Source line? Then you could just change the parameter settings when promoting from dev to prod.