Forum Discussion
Updating multiple data sources to a new database.
hello jackcoxer . I had the same challenge on my recent project, where I had created the PowerBI solution on an SQL server (lets call it TEST) and wanted to transfer the BI report to another SQL server instance (lets call it PRODUCTION).
The way to do this is by adding parameters to your datasets.
What you have to do is:
1. Open the Dataset
2. Transform Data (this brings you to the Power Query Editor)
3. On the Power Query Editor go to Manage Parameters -> New Parameter
-> Here create the 'Environment' or 'DB' parameter , depending on what you want to do and enter the instances as TEXT in a list of values.
4. Go to the Advanced Editor (if you dont know how to do this check it out here: https://learn.microsoft.com/en-us/power-bi/transform-model/desktop-query-overview ) and use your Parameter from Step 3.
This requires that the SQL tables you are querying are exactly the same, otherwise your query/queries will break in PowerBI.
5. Optional: Create your PowerBI Pipeline and use the parameter accordingly . This will help automate deploying fixes/changes from one PowerBI to the other.
Please visit my blog for more info: https://www.iipowerblog.com/
Does this help you? If yes please accept my solution! Thanks!
hello jackcoxer . I had the same challenge on my recent project, where I had created the PowerBI solution on an SQL server (lets call it TEST) and wanted to transfer the BI report to another SQL server instance (lets call it PRODUCTION).
The way to do this is by adding parameters to your datasets.
What you have to do is:
1. Open the Dataset
2. Transform Data (this brings you to the Power Query Editor)
3. On the Power Query Editor go to Manage Parameters -> New Parameter
-> Here create the 'Environment' or 'DB' parameter , depending on what you want to do and enter the instances as TEXT in a list of values.
4. Go to the Advanced Editor (if you dont know how to do this check it out here: https://learn.microsoft.com/en-us/power-bi/transform-model/desktop-query-overview ) and use your Parameter from Step 3.
This requires that the SQL tables you are querying are exactly the same, otherwise your query/queries will break in PowerBI.
5. Optional: Create your PowerBI Pipeline and use the parameter accordingly . This will help automate deploying fixes/changes from one PowerBI to the other.
Please visit my blog for more info: https://www.iipowerblog.com/
Does this help you? If yes please accept my solution! Thanks!
Thanks for the reply - So would this be the case for every report where the old database has a connection?