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

Be one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now

Reply
dedelman_clng
Community Champion
Community Champion

newly created OData-based Dataflow not available in Desktop

I created a dataflow in the Service (Pro) using OData as the data connection for 4 tables. It has automatically refreshed a couple of times already, but when I try to consume the data in PBI Desktop (2.126.927.0 64-bit (February 2024)), it is not shown as an option. The workspace (Engineering) it is in does not even show as an option in the hierarchy.

 

Should see "Engineering" at the same level as General SpendShould see "Engineering" at the same level as General Spend

 

A different data flow in a different workspace (General Spend) using HANA as a source works as expected. Is there something about OData that prevents it from being shown in Desktop, or some kind of configuration with the workspace I need to look at?

 

Thanks in advance

David

 

 

6 REPLIES 6
lbendlin
Super User
Super User

Is this on Premium?  Did you publish the app? Did you click on the app link to "install"  the app?

HI @lbendlin 

 

This is Pro space, not premium. I have republished the app that contains the dataflow (even though there is no plave for me to tell the app to include the dataflow?) with no luck. The app is set to auto-install.

 

It does, however, appear when I use "Power BI dataflows (Legacy)" as the connector.

 

When re-publishing the app I also upgraded the app to the "new" version - do I need to recreate the dataflow now that the workspace and app are both upgraded?

 

Thanks

David

Should be ok.  One more question - did you refresh the detaflow?

It has been refreshed several times.

 

The fact that it appears in Power BI dataflows (Legacy) makes me want to create another similar one, now that the workspace and app have been upgraded. I will report back when I have done so.

 

David

I recreated the dataflow in the same workspace, and then created a new workspace and built it there. Neither of those show up in the "Dataflow" connector, but both show up in the "Power BI dataflows (Legacy)" connector.

 

Could it be that OData is not supported in the modern dataflow, so it is defaulting to a legacy one?

This doesn't mention ODATA specifically but it mentions Direct Query...

 

Differences between Dataflow Gen1 and Dataflow Gen2 - Microsoft Fabric | Microsoft Learn

 

Not sure.

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Dec Fabric Community Survey

We want your feedback!

Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.

ArunFabCon

Microsoft Fabric Community Conference 2025

Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.