Forum Discussion
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 se...
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.
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?