Changing data source from odata feed to data flow in report?

[colonel_claypoo]

Hi there,

I have a report which has a live connection to an odata feed. This feed should be moved into a data flow. In order to retain all visuals in the report I would like to change the report's data source from odata to data flow. This is so that I don't have to rebuild all visuals as if I had to when creating a new report from scratch that uses the data flow as its source.

Unfortunately though in the Power Query editor the "Change data source" button is always grayed out. And in the Advanced Editor for a table the code is too different so that I don't know if the data source can be changed from odata to a data flow.

Do you know if this is possible?

Thanks.

[ALLUREAN]

If you achieve the new source (dataflow) has the same structure like the odata will be relatively easy to edit the code

[colonel_claypoo]

Well, in the OData query there're a bunch of custom fields and if/then/else conditions. When I go to create the dataflow the query for the table copies just fine from Desktop PowerQuery to the dataflow (browser) PowerQuery editor.

However, when I create a new Desktop file and connect through dataflow the query for that table is different. It only contains the query strings for the dataflow:

And I've not been able to successfully combine the dataflow source with the conditions which are the basis for the visual reports of which I want to substitute the OData source with the dataflow source.

Any ideas are welcome.

Thanks.