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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
odatauser1
New Member

OData connector does not support any() for Odata V3 due to bug

I have encountered an issue where the OData connector does not send a filter containing any() correctly to an OData V3 service. Instead of returning the filtered data, all data from the endpoint is returned.

 

Does anyone have a workaround or the ability to escalate this issue/bug to the Power BI Team?

 

Here are the steps to reproduce in Power BI Report Server Edition (May 2023). I am using the public odata.org Northwind database so anyone should be able to reproduce.

 

Using a V4 endpoint the filter works as expected:

v4.png

 

Using a V3 endpoint the filter does not work as expected. All rows are returned:

v3.png

 

Using a browser (Edge) to query the V3 endpoint, the filter works as expected:

browser.png

2 REPLIES 2
v-junyant-msft
Community Support
Community Support

Hi @odatauser1 ,

I did reproduce the issue you're facing, but Power Query supported the V4 version back in 2017.
Solved: Highest OData version? - Microsoft Fabric Community
There is a big difference in functionality between V4 and V3, and I still recommend you use the V4 version. Also, I'm not aware of anyone else reporting the same issue at this time, and I'm not aware of the same issue in the existing known issue. If others report the same issue in the future, I will report this issue.

Best Regards,
Dino Tao

Thanks for taking the time to reproduce the issue. I do not have the option of switching to Odata V4, because the endpoint I am requesting data from only supports up to V3.

 

I would much appreciate if someone reading this can escalate this bug to the Power BI team.

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

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

July Newsletter

Fabric Community Update - July 2024

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

Top Solution Authors
Top Kudoed Authors