Forum Discussion
Semantic model to large
Model size isn't based on the number of records but the kind of data. A table with 2M rows and 4 columns can be smaller than a table with 100K records and 200 columns.
It also depends on the data in the columns. Integers store very well. Long LONG text strings do not.
You need to get DAX Studio and use the Veritipaq Analyzer tool within it. https://daxstudio.org
The second video here on Performance Tuning will show you how to use that tool. https://daxstudio.org/docs/Videos/
From there you can figure out what you need to do to reduce it, or find out you cannot remove anything and upgrade to a Premium Per User license that allows semantic models to grow to 100GB vs 1GB for Pro.
Model size isn't based on the number of records but the kind of data. A table with 2M rows and 4 columns can be smaller than a table with 100K records and 200 columns.
It also depends on the data in the columns. Integers store very well. Long LONG text strings do not.
You need to get DAX Studio and use the Veritipaq Analyzer tool within it. https://daxstudio.org
The second video here on Performance Tuning will show you how to use that tool. https://daxstudio.org/docs/Videos/
From there you can figure out what you need to do to reduce it, or find out you cannot remove anything and upgrade to a Premium Per User license that allows semantic models to grow to 100GB vs 1GB for Pro.