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

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

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
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

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

Top Solution Authors
Top Kudoed Authors