oData $filter when datatype is 'Any'

[jvermette09]

Hello,

I am using power query editor to grab some data from an oData feed and I can't get the $filter functionality to work whenever the data type of a field is 'Any'.  It works fine if text/number/date.  Is there a way around this other than filtering after it lands in PQ?

[v-angzheng-msft]

Hi, @jvermette09 

Power query requires a data type to execute the M query code and make query folding work.

If user filter Documents in the Power BI query editor (using the standard checkbox filter) on any property other than Description (which is annotated as non-filterable), the filter is passed through.

Refer:

OData filter pass-through

Filtering in Power Query Editor not working for OData source

Troubleshooting Data Refresh Performance Issues With OData Data Sources In Power BI And Excel Using ...

Best Regards,
Community Support Team _ Zeon Zheng

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[jvermette09]

Thank you for your response.  So what you are saying is you have to filter the data after it loads to PQ, and I cannot get the performance improvement of applying the fitler in the oData url?