Skip to main content
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.

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 Northwind database so anyone should be able to reproduce.


Using a V4 endpoint the filter works as expected:



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



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


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

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


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.

Top Solution Authors
Top Kudoed Authors