Highest OData version?

[coreyw]

Can anyone tell me what is the highest level of OData that Power BI supports as a data source?

[hugoberry]

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"

[coreyw]

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-msft]

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

[coreyw]

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.

[hugoberry · Accepted solution]

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?