In order to request aggregates from large views in Data Modeling into PowerBI, it would be beneficial to have the /aggregate endpoint exposed in OData (and PowerBI as a result). Otherwise all the data needs to downloaded to PowerBI first and perform the aggregates locally, this lowers the performance and is not possible for views with millions of instances.
Hi@Christian Flasshoff ,
@Elka Sierra will review it and come back to you.
We have received your request and our PM
Thank you,
Andreea.
This is a high priority for Celanese. Please mark it as Critical@Hunter Beck
I very much support this, if the aggregation could be done already with the native query into CDF it would provide huge benefits.