Switching report from local dataset to Power BI Service Live Connection

[mda]

I have a report which is build using its own dataset (import query).

But now I've created a dataset with the same data, which is published in my workspace.
This dataset will be shared across many reports.

The problem is that Power BI doesn't allow me to switch to live data from Power BI Service dataset.

How can I do it?

I don't want to build my report from scratch.

Do I have to delete all local datasets and then it will be possible to select remote dataset?

[Greg_Deckler]

I am not aware of a way to switch from import mode to live mode. You could try removing all of your queries and then connecting to the live data set but I would only do that on a copy of the report.

[davinj]

Very old thread, but I had the same question and was able to answer it. The answer is YES! I was doing so to allow my coworkers and I to all work off a shared team site's sharepoint files (directly imported into PowerBI) and have less confusion. I often build the queries and initial report, then they continue developing the report. This gets too complicated to manage when I need to update the back end queries and they are trying to update the report.

First, make two copies of your report. The first is Copy1_Dataset, the second is Copy2_Report. Connect Copy1_Dataset to the PowerBI online service so the dataset is available.

Open the Copy2_Report and then Edit Queries. Delete all the queries and apply changes (you must first apply the deletion before connecting to a PowerBI Dataset is available) Your report will refresh to lots of Xs. Click Get Data, PowerBI Dataset and navigate the the dataset and click Connect. The datset will load and your report is now a live report and you have split the front and back end of your report.

[Ghuiles]

@davinj Your idea sounds great, but somehow it does not work for me. 

I deleted all queries, applied the changes, all charts are marked with an X, but then i still get the error message that the "connect live option is disabled because it already contains data from another data source.."

Do you have any clue on how could i solve this?

BR, G.

[Ghuiles]

Just found the solution to my problem!

@davinj you were right! it works! 🙂 so kudo 🙂

What i had to delete additionaly are the calculated tables i generated in DAX.

BR. G.