Forum Discussion
Disconnect Power BI Report from Power Platform Data Source
I see the data and modelling options appear only for original dataset and not for the dependent reports(report created from datasets) even if we download the report .pbix. To reuse the visuals and bookmarks, instead of copy-paste all the visual to new report, you could model and publish your excel based dataset to service and point the report which you intent to reuse to newly published(excel based) dataset.
v-diye-msft I am too interested to see an option to change the source other than PBI service datasets.
If it helps, mark this as a solution.
Hi Anonymous
You can download the pbix here:
The report will be kept and you can also use the dataset for further modifications.
v-diye-msft Hi Dina, I can download the pbix file fine, but the problem isn't downloading the file, the file is still connected to the dataset which means I cannot connect to another non-live dataset (e.g. a csv file not on the Power Platform [e.g. Power BI dataset]).
The only way that seems to be possible is to manually copy and paste every single visual from every single screen to a new Power BI report, which seems like madness to me...
Si
I believe you can do CTRL+A to copy and paste a whole page to another report, that makes it a little less cumbersome.
When live connected to a Power BI dataset you can indeed not change it to an offline source. Although not want you want, you can however change to a different dataset already in the service by clicking on Edit Queries > Data source settings.
Did this help you or did I answer your question?
Then please give kudos or mark my post as a solution!
My blog: nickyvv.comnickyvvthank you, Nicky, Ctrl-A does help - though sadly still have to re-create my (rather substantial) number of bookmarks!
(This is the dashboard in question - https://smarturl.it/CitywideIntelHubSCL)
Hi Anonymous
When you download the pbix from report panel, it will work as an offline pbix . that you can open it directly which same as the import mode not live-connection. like below:
Please kindly double check your operation.
Hi Dina v-diye-msft , I've tried it over and over again (and can screen record it!) and certainly even the offline file isn't disconnected from the live dataset.
I can attach the original Power BI file and send it to you if it helps figure out what's gone wrong?!
Thank you
Si
I see the data and modelling options appear only for original dataset and not for the dependent reports(report created from datasets) even if we download the report .pbix. To reuse the visuals and bookmarks, instead of copy-paste all the visual to new report, you could model and publish your excel based dataset to service and point the report which you intent to reuse to newly published(excel based) dataset.
v-diye-msft I am too interested to see an option to change the source other than PBI service datasets.
If it helps, mark this as a solution.
