PowerBI data source Dev / QA / Prod

[raghuv2010]

We have a scenario to develop PowerBI Reports using one data source and publish / validate against a different data source of a similar structure. We Develop using a DEV database data source with credentials embdded on the PowerBI Desktop . The databases have similar structures but have additional volume of data.

we intend on publishing same pbix to different workspaces one for each Dev/Certification/Prod. Looking for a solution not to have the PBIx edited for connection details wile publishing to each workspace.

any suggestion is greatly appriciated.

[GilbertQ · Accepted solution]

Hi @raghuv2010 

You could use the Deployment pipelines with more information here: Power BI Application lifecycle management (ALM) deployment pipelines overview - Power BI | Microsoft...

Or you could create parameters and change this in each of the different App Workspaces after you upload the PBIX report here: Using the Power BI Service Parameters to change connection strings (To possibly change between Dev, ...