Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe 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.
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:
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.