Forum Discussion
changing data source in existing PBIX when current data source is not available
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!!
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.pbir
Open 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!!
Thank you, Naveen. I will try this on Friday and update, including Accept as Solution, once I've given it a go. Much obliged!