Forum Discussion
changing data source in existing PBIX when current data source is not available
- 2 years ago
Please keep backups of all the files.
In client A save the report as PBIP[enable PBIP from preview features in PBI desktop first], Then you can navigate to the below file.
PBIP saved folder -->Report_name.Report-->definition.pbirOpen the definition.pbir using notepad, You will see the SSAS connection string in there.
In client B create a new report using live connection from PBI Model, Use the same method as above to get the connection string for this.
Now try to swap and play around with the connection string from B to A. [Then bring back the file to B]
I have executed something very similar, It might get tricky with the changes, but if done proper , this would work.
Let me know if you have any questions.
If this post helps, then please consider Accept it as the solution to help the others find it more quickly. Appreciate you kudos!!
Hi Naveen -- I tried your suggestion today and it works great. The reports need a little stitching up once brought to client B, but this was expected. Overall, your flow did exactly what I needed it to do. Thank you very much! Regards.
Thanks Mark, Glad to be of help 🙂