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 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
Hi Anonymous
I got it. It's live-connection mode when you create the reports in desktop and publish it to service afterward. That will make sense why live-connection still on when you open it offline. But sadly that, it's not able to change it as import mode from live-connection mode.
Thus I don't think there's an easy way to work it out currently. I'll look into it today and keep you updated.
Thank you v-diye-msft I would really appreciate that. And thank you VasTg I didn't think of modelling the data in Excel and turning that into a new dataset to connect 'live' -- that worked!
Anonymous
Glad it helped..
Thats how we handle ALM with Dev, Beta and Prod workspaces simply by changing the datasource on the dataset and pointing the report to corresponding datasets.