Forum Discussion
Size Issue
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
4 Replies
Please clear my confusion in this
amitchandak Greg_Decklermh2587 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.
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.Nope I didn't
