Odata - Enabling Native query - Native queries aren't supported by this value. Details: [Table]

Hi GermanAravena , In the example that Patrick shows, there is a connection to SQL Server data source.  This data source supports Query Folding by default.  You connection is using a OData connection, so it is possible that the OData data source may not support Query Folding.  In this situation the "services.odata.org" northwind does not support query folding.  Please note the "Query Folding" relates to whether the Client (i.e. your Power BI Desktop) or the Server (i.e. the Odata datasource) is using the CPU to process the query.  If the data source is an SQL Database, the database CPU can be used to process the query then return the results.  In your situation, the OData feed is not hosted on a database.  It is technical just a Blob storage.  There means that you need to return all the data from the Datasource to your Local Client to process the query.  I hope this help you understand.