At the Power BI world tour in Copenhagen last week I was asked how to change a Power BI report’s connection from a dataset in the service – for instance if you have a test workspace and then want to move the report to a production workspace.
I started to refer to my previous blogpost – https://eriksvensen.wordpress.com/2017/10/03/how-to-change-the-powerbi-desktop-file-connection-from-data-model-to-a-power-bi-service-dataset-or-azureas/ – but when using this hack it won’t work.
So we have to do it in another way and it is quite simple – one important thing is of course that the dataset has the same dimensions and measures – otherwise some of your visualisations will show an error.
When we create the report we can select a Dataset from the service
When we save the report it will automatically be saved in the workspace where the dataset resides.
But how can we change it –
If you go to Edit Queries
You can click Data source settings – then we will get the option to pick a dataset from another workspace
And then you just pick the dataset you want to use.
When you save the report now – the report will be saved in the workspace where the selected dataset resides.
Hope this can help you as well – and if so give this post a like