Power BI Tips & Tricks — 5 Simple Changes in Power BI to Reduce Data Model Size by 99%

Author: Akshay Mishra

Platform: Medium.com

Duration: 8 min

Level: Beginner

Topics: Data Model, Power Query

Summary by author Akshay Mishra :

When you work with large data models, one thing that bothers us the most is the performance of the reports. As a Power BI Architect, I have worked on a variety of data models — from small ones with just hundreds of rows to larger ones with up to billions of rows. And guess what, the most common ask from any client is that they want a dashboard with optimized performance.

Though there are multiple ways to optimize the performance of a data model, the primary thing is to reduce its size. Power BI models in Import mode are loaded with data that is compressed and optimized and then stored to disk by the VertiPaq storage engine. When source data is loaded into memory, it’s possible to see up to 10x compression.

This can be done in really simple steps. Here, I list down 5 very simple methods to do so. I’ll be using DAX Studio and VertiPaq Analyzer to demonstrate before and after analysis on the changes.

Read the full article here:

👉 5 Simple Changes in Power BI to Reduce Data Model Size by 99%