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

[odatauser1]

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:

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:

[Anonymous]

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

[odatauser1]

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.