Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
colonel_claypoo
Regular 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 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.

2 REPLIES 2
ALLUREAN
Solution Sage
Solution Sage

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




Did I answer your question? Mark my post as a solution!


https://allure-analytics.com/
https://www.youtube.com/channel/UCndD_QZVNB_JWYLEmP6KrpA
https://www.linkedin.com/company/77757292/

Proud to be a Super User!




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.

2.png

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:

 

1.png

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.

 

 

 

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.