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

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