Forum Discussion
How to Update Dashboards after Data Cubes Migrated between SSAS
yintluo If you started with the Desktop, and built your reports and published the PBIX to the Service and created dashboards, then the following should be true.
You would create a new data source in the Gateway.
You could modify the data source in the Desktop file to the new one, and when you executed the "Publish" to the same workspace a notification should appear saying that you are going to overwrite your existing dataset. At which point, a publish would update the existing dataset/reports. If the name of the PBIX is the same, everything should just be replaced and you shouldn't need to re-create all the dashboards...
If you built the report based on a dataset in the Service that directly connected to the SSAS instance, then I would assume you would have to do what you described.
yintluo If you started with the Desktop, and built your reports and published the PBIX to the Service and created dashboards, then the following should be true.
You would create a new data source in the Gateway.
You could modify the data source in the Desktop file to the new one, and when you executed the "Publish" to the same workspace a notification should appear saying that you are going to overwrite your existing dataset. At which point, a publish would update the existing dataset/reports. If the name of the PBIX is the same, everything should just be replaced and you shouldn't need to re-create all the dashboards...
If you built the report based on a dataset in the Service that directly connected to the SSAS instance, then I would assume you would have to do what you described.