Forum Discussion
Importing reports from one Workspace to another
I am having issues when I change a data source from one PBI Workspace to another. The PBI datasource is the same SSAS service model for both workspaces.
Within PBI desktop I chose "Edit Queries" -> "Data Source Settings"
I then browse to the "new" workspace (which has a PBI connection to the same SSAS model as the original workspace, the datasource is named the same as the original)
After chosing the new workspace data source, many of my visualisations report an error (meaningless one!)
If I then save my PBI report, close, then reopen, some of the visulisations seem to be working again, but not all.
When I review the visualisations that are still not working, it would seem that the user (creator of the report) has renamed the fields for the visulisation. Could this be the cause?
Any ideas?
I think I have worked out the issue.
When I open the PBI Desktop report and change its datasource from one workspace to another workspace (remember, the difference between the 2 connections is one is pointing to the production the other to the development of the same model), the PBI visualisations all display errors. Nothing I do at this point will correct the errors.
However, if I save, close, then reopen the PBI report, all of the visualizations (pointing to the new source) work; even those that are pointing to renamed columns.
There is a small element of inconsistency with this behaviour if the user has added a calculated measure, further investigation on this.