Size Issue

mh2587 · ‎12-09-2022

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
image (5).png

✔ Answered? Mark as solution

Muhammad Hasnain | Super User • Fabric • Power BI • Data Engineering

Let's connect on LinkedIn

ThomasWeppler · ‎12-09-2022

Hi Muhammad
I notice that the size through SQL server properties are twice as large as the through DAX queries after roundings.
Can you have downloaded the data twice?
Just a question that might help you to start looking for a solution somewhere.

mh2587 · ‎12-09-2022

Nope I didn't

✔ Answered? Mark as solution

Muhammad Hasnain | Super User • Fabric • Power BI • Data Engineering

Let's connect on LinkedIn

mh2587 · ‎12-09-2022

Please clear my confusion in this
@amitchandak @Greg_Deckler

✔ Answered? Mark as solution

Muhammad Hasnain | Super User • Fabric • Power BI • Data Engineering

Let's connect on LinkedIn

Greg_Deckler · ‎12-09-2022

@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...