Skip to main content
Microsoft Idea

Power BI


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