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.
Anonymous
Once we will select any Power BI Service dataset in Power BI Desktop, it will take it as "Live Connection" and it will show only "Report View". We can't able to view "Data View and Relationship View", "Edit Queries"..etc. All other options will be greyed out.
Please refer the below snippet for reference.
If you want the "Edit Queries" option, please download the existing report from the Power BI Service and develope the report as per the business needs and save the file with different name and publish to the Service.
There in one more way, we can achieve it from the data flow, please refer the link for more details.
If this post helps, then please consider Accept it as the solution to help the other members find it more
If this post was helpful may I ask you to mark it as solution and give it some kudos?