Skip to main content

Power BI

New

Optimize OData4 query removing duplicate OR-clauses, remove superfluous filters and using IN.

Vote (2) Share
Guido Leenders's profile image

Guido Leenders on 24 Feb 2022 11:06:54

Power BI does not optimize the OData4 query when filtering on a number of values for a field. For example, it is not uncommon that identical filters are added multiple times with the OR-operator, required fields compared with null and an OR-operator used when IN could be used.


This considerably reduces performance in several scenarios and exhausts the available URL length which is 1500 bytes on some intermediate platforms.


See also https://community.powerbi.com/t5/Power-Query/Use-of-OData-IN-operator-instead-of-ORs/m-p/1966857#M57973