Optimizing the size of queries
In this section, we'll look at some other data preparation best practices that can make our model a better model. Optimizing queries' sizes can reduce the data refresh time. A model with an optimized size performs better after we import the data into the data model. In the following sub-sections, we'll look at some techniques that help us in having more optimized queries.
Removing unnecessary columns and rows
In real-world scenarios, we might deal with large tables with lots of rows and columns. Some Power BI developers tend to import all columns and rows from the source, ending up having poor-performing reports. Power BI uses the xVelocity engine, which uses in-memory data processing for data analytics that works based on column cardinality. Therefore fewer columns directly translate to less memory consumption and as a result, a more performant data model. In many real-world cases, we need to discuss with the business to make sure...
