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
Do you mean you'd like to use the dataset in service but modify the report? Since this is a live connection, left-navigation and modeling are disabled, similar to the behavior when connected to SQL Server Analysis Services, and you can only connect to one dataset in each report. you can refer to this article for more limitations:
Instead of connecting to the dataset by live-connection, you can download the dataset from service and create a new report.
You can create a new dataset and then change the live connection. You would need to assign the same lineage tag (using tabular editor) to the equivalent objects (tables, columns and measures) as in the original model, at least the ones used in the report.
Or, if it's simply a change of one of the sources in the original report, keeping the structure, you can parametrize it and publish under a different name. The latter can be done entirely in the service by copying the dataset, update the parameters values and refresh.