Size Issue

[mh2587]

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

[ThomasWeppler]

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]

Nope I didn't

[mh2587]

Please clear my confusion in this 
@amitchandak @Greg_Deckler 

[Greg_Deckler]

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