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!!
Hi
Does the report have a live connection to a SSAS model in client A? Also when you say in client B the model is in Power BI service, Is it again a live semantic model that connects to a SSAS?
Regards,
Naveen
Hi Naveen. In client A, yes the reports have a live connection to the model in SSAS. I don't think it matters for this discussion, but for fuller context, that SSAS model is then connected via Direct Query to SQL.
In client B, it also will be a live connection to the model, with the model this time hosted in Power BI. However the Power BI model will be in-memory rather than Direct Query back to SQL.
Mark
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!!Thank you, Naveen. I will try this on Friday and update, including Accept as Solution, once I've given it a go. Much obliged!
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 🙂