Power Query Odata Filter List Of Items

Posted on
Filter

I have found, through experimentation, that setting filters on properties annotated with Org.OData.Capabilities.V1.FilterRestrictions.NonFilterablePropertiesresults in Power BI filtering the data locally, whereas filterable properties result in a '$filter=' query being passed to the source service. However, Power BI appears to ignore other FilterRestrictions annotations, such as RequiresFilterand RequiredProperties.Is there any documentation or reference sample to explain the extent of annotation support for OData v4 services, particulary the Org.OData. Capabilities.and Org.OData.Core.

Odata Filter Query Sharepoint

annotations?Any help would be appreciated.