Every visual shown in a report in PBI, contains some form of aggregation
The question is how the aggregations are calculated and at which step in the pipe of bringing the data from the data source to the report.
In this article, I’ll be using data coming from Azure Data Explorer aka Kusto aka ADX.
Most of the content is relevant for other sources as well.
Read on for the advice, which I’d call fairly unexpected—I actually expected the recommendation to go the other way for performance reasons.