Optimizing distinctcount with reduced memory consumption in PowerBI (VertiPaq)

High cardinality columns are often the problematic part of the data modeling in most environments, including PowerBI. Since the PowerBI data model resides on a columnar database, having high cardinality columns impact both performance and the size of the model. This is especially the case with columns having more than 2 millions of distinct values. …

Optimizing distinctcount with reduced memory consumption in PowerBI (VertiPaq) Read More »