5 Simple Changes in Power BI to Reduce Data Model Size by 99%🤩
Yes, its possible and here is how you can do it. 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. Despite VertiPaq storage engine efficiency, it’s important that you take steps to minimize the data that is loaded into your models. This can be done in really simple steps. Here, I list down 5 very simple methods to do so. I’ll be...
