Forum Discussion
Highest OData version?
- 9 years ago
Sorry to be blunt here, but coming back to my answer. Power BI OData feed supports V3 and V4. Version 4 being the highest supported version at the moment. Would that answer your question?
Check the documentation that comes with your version of Power BI Desktop
Type the folowing query to see lots of goodies
=#shared
The one of interest you is
= #shared[OData.Feed]
My documentation says the following
"ODataVersion: A number(3 or4) that specifies the OData protocol version to use for this OData service"
- coreyw9 years agoHelper I
Cool. That's an intersting feature.
Actually, my question is a little more generic. I should have phrased it: what is the highest level of OData service that I can successfully query via Power Query/Power BI Desktop?
- v-qiuyu-msft9 years agoCommunity Support
Hi coreyw,
I'm not clear about the exact "highest level of OData service" you mean. But how can we get data use OData data source should depend on the target data source.
Best Regards,
Qiuyun Yu- coreyw9 years agoHelper I
Hi v-qiuyu-msft,
The OData specification has several versions V1 through V4+, What is the highest level ODATA standard that the OData connector can successfully query?
It's of concern to me because OData V4 deprecated some query keywords present in previous versions. So if I write a custom OData source conforming to V4 and if PowerBI only knows about V2, Power BI will not be able to query it.
Setting up a V3 versus a V4 data source in Visual Studio is a huge difference.