Advanced Editor for Published Data Sets

[Anonymous]

I am trying to replace data sets people have used in their reports which are direct to the data warehouse (sql views), with published ones I have created.

Previously I would add in the published data set, then copy over the code from the advanced editor and replace the code for the existing data set.

Now it seems I cannot see the advanced editor when I connect to published datasets, which is this?

What is the best way to resolve this situation if I can no longer use this method.

[amitchandak]

@Anonymous , if a power bi file is using dataset, just use edit data source and you should be able to change that

[Anonymous]

Doesn't seem to let me swap from a direct query in SQL, to the publisehd dataset.  Bottom to top in picture.