File size not changing when deleting a table

[soldstatic]

I've changed some formulas and such in order to calculate some KPIs without 'aggregate' tables from the sql database. These tables grouped up by date the KPI for each customer, and were HUGE tables, couple million rows each. I've deleted them from the model but the file size hasn't changed hardly at all, maybe 2,000 kB (overall file is 650,000 kB ). I'm really surprised it didn't have a bigger impact. 

I've changed the file extension to .zip to see what's in it, but I don't see a great way to explore the data model piece to confirm that the data is gone. Any ideas?

[v-juanli-msft · Accepted solution]

Hi @soldstatic 

You could analyze data model size with VertiPaq Analyzer,

Where you could find data size for each table/column.

https://www.sqlbi.com/articles/data-model-size-with-vertipaq-analyzer/

To get a better performance, you could learn from these articles.

https://docs.microsoft.com/en-us/power-bi/power-bi-reports-performance

https://www.sqlbi.com/articles/introducing-the-power-bi-performance-analyzer/

Best Regards
Maggie

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[soldstatic]

Thank you! I think that VertiPaq is what I needed, thanks so much!