OData server side support

[Anonymous]

Is there a definitive list/roadmap anywhere that shows what Power BI/Power Query is able to offload to the server for OData queries?

In playing around with Power BI I have found the following thus far:

- Group By aggregation operations always seem to be done on the client (paging through the entire dataset and aggregating locally) and it never appears to attempt to do them in the server request

- Filter and OrderBy operations seem to work some of the time server-side with a fallback to client-side if initially unsuccesful 

It appears you may be able to hand-craft the request in the advanced editor to achieve whatever operations you need, but i'm primarily interested in how much can be done via the UI without explicit user knowledge of how to write a query URL for more advanced operations.

[v-yanjiang-msft]

Hi @Anonymous ,

Please see if the solution can help: asp.net web api - OData V4 modify $filter on server side - Stack Overflow

Best Regards,
Community Support Team _ kalyj

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

[Anonymous]

Thanks for taking the time to reply but that link isn't really the question I was asking. We're perfectly capable of supporting the odata standard at the server end but I was more asking about what operations Power BI can transparently at least try to offload to said server rather than sucking up entire huge datasets and performing them at the client end.  I'm able to observe it trying to do filter and order operations in the URL it generates to the data source but not so much anything else like aggregation and I wanted to find out definitively what is supported now and what may be supported in the near future.