Hi
I have an issue with the SQL server analysis service. I load data into a tabular model and check its size through DAX queries the estimated size of all the tables is approx 2.8 GB and when I check the size through SQL server properties it shows approx 5.7 GB. I want to know why it is behaving like this...Thanks
I have an issue with the SQL server analysis service. I load data into a tabular model and check its size through DAX queries the estimated size of all the tables is approx 2.8 GB and when I check the size through SQL server properties it shows approx 5.7 GB. I want to know why it is behaving like this...Thanks
@mh2587 Is the SQL Server Analysis Services data source also a tabular cube? If it is not, then it doesn't have the same compression of the Vertipaq engine that the tabular cube in Power BI is using.
Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!: DAX For Humans
DAX is easy, CALCULATE makes DAX hard...
Helpful resources
Data Days 2026
Don't miss out on Data Days, June 15 through August 7. Learn Fabric, Power BI, SQL, AI and more.
Power BI DataViz World Championships - June 2026
A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.
