Change datasets without changing dashboard reference and URL

[ToMiiTo]

Hi everyone,

I am currently working on migrating our dashboard architecture to the Cloud.

We are moving from a SSAS/Power BI Report Server stack to a semantic model/Power BI Cloud one.

The first step was to migrate the Power BI part which has been done successfully. The Power BI on Cloud connects to SSAS with a gateway and we have sent the new URL of the dashboards to the users.

The next step is to change the data source of every dashboard, which has to be a Cloud semantic model instead of a SSAS.

However if we try to upload the dashboard with the new data source directly we then get a "Something went wrong" error.

The only way we have found around this is to delete the old dashboard and then upload the new version, but then the URL is changed, and sending the new URL to all the users for every dashboard will look silly.

Do you know if there is a way to keep the existing dashboard and its URL when changing the data source ? Also, about the "Something went wrong" error, is Microsoft considerating this as a bug and working on this, or is it considered as an explicit feature ?

Thanks a lot,

[ToMiiTo]

When I upload the dashboard in the same workspace with the new dataset the way you have mentionned, first I have this pop-up appearing :

and when I click on Replace it, I got this :

So it's seems the only approach working is to delete the old dashboard first and then to redeploy the new dashboard

[AnkitKukreja · Accepted solution]

Hi! @ToMiiTo 

Are you referring to a dashboard or report? The snapshot you are showing is for publishing a report from the desktop, so that is a report. If you publish it after changing the sources, you will see this message, which is by design. And one you replace that in Service the dashboards should be in a sync.

[AnkitKukreja]

Hi! @ToMiiTo 

Once you update the data sources in Desktop file make sure you publish the report back into same workspace and if this order is maintained all your dashboard will pickup the tiles from your existing reports unless you have made changes to the schema of the existing data.
Otherwise, you will have to follow the second approach that you mentioned, re-publish all the dashboards and share it again if changes were made to the schema.

[Duane344Gray]

Hello!

To change the data source of your Power BI dashboards without altering the URL, open the report in Power BI Desktop, update the data source under File > Options and settings > Data source settings, and then publish it back to the same workspace. This should retain the original URL. For the “Something went wrong” error, check the Power BI support page for updates or workarounds.