Forum Discussion
colonel_claypoo
4 years agoFrequent Visitor
Changing data source from odata feed to data flow in report?
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 d...
ALLUREAN
4 years agoSolution Sage
If you achieve the new source (dataflow) has the same structure like the odata will be relatively easy to edit the code
colonel_claypoo
4 years agoFrequent Visitor
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.