Forum Discussion
PowerBI data source Dev / QA / Prod
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.
Hi raghuv2010
You could use the Deployment pipelines with more information here: Power BI Application lifecycle management (ALM) deployment pipelines overview - Power BI | Microsoft Docs
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, Test & Prod) - Reporting/Analytics Made easy with FourMoo and Power BI
1 Reply
Hi raghuv2010
You could use the Deployment pipelines with more information here: Power BI Application lifecycle management (ALM) deployment pipelines overview - Power BI | Microsoft Docs
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, Test & Prod) - Reporting/Analytics Made easy with FourMoo and Power BI