Reply
Regular Visitor
Posts: 16
Registered: ‎02-16-2017

Changing datasource when using Power BI Live Service dataset

Our Power BI environment has a DEV group and Prod group. Users run their reports from Prod, and

developers create reports in the Dev group and then use the File->Options and Settings->Data source settings to

change the report to point to the Prod database, save the  report and then publish to the Prod group.  This has been working fine.

 

We are now trying to build reports using a single Power BI Live Service dataset functionality.  We have the same dataset

defined in Prod and DEV groups (each being refreshed via the Gateway from the Prod or Dev databases).  

We created a report using the DEV dataset under the DEV group.  We now want to publish that report to the Prod group,

but it will not let us. It will only let us publish to the group where the underlying dataset was originally from.  I tried to

use the "File->Options and Settings->Data source settings" to see if I could change the source of the underlying dataset, but that function is greyed out.

 

How can I publish my report to the Prod group and ensure it is using the Prod instance of the dataset?

I do not want to have to recreate the entire report as that seems error prone.

 

Super User
Posts: 7,413
Registered: ‎07-11-2015

Re: Changing datasource when using Power BI Live Service dataset

Try this. Create a new PBIX that connects to your prod system. Copy the PBIX to a .zip file. Open the zip file and copy the Connections file. Copy the dev PBIX file to a zip file. Replace Connections file with the copied one. Copy this PBIX back to a PBIX with a different name for prod. Might work.









Did I answer your question? Mark my post as a solution!



Proud to be a Datanaut!










Highlighted
Regular Visitor
Posts: 16
Registered: ‎02-16-2017

Re: Changing datasource when using Power BI Live Service dataset

Tried doing this but I get an error message when I tru to open the newly created PBIX file.

"Test.pbix is corrupt ot an invalid report file".   Perhaps there are checksums that no longer match

once I replace the Connection file?