Reduce cardinality levels to improve performance – Model the data
Reduce cardinality levels to improve performance Power BI employs several compression mechanisms to reduce the size of data, the details of which are outside the scope of this book. One way to decrease the data size, which we cover next, is by reducing the cardinality of columns by changing data types or the default summarization. […]