Hello, I've been working on building a Power Query database as my formula based DBs are too huge to manage.

It's all going really well and I had got everything I needed and was only at 536KB.

I then put in some pivot reports and charts and KPIs etc and my size jumped to 6,138KB!!

I didn't need any of that stuff so I deleted it expecting the size to reduce again but it hasn't.

Does anyone know why removing the cause of the jump wouldn't reduce the size back down?

I guess I'm thinking is there a function like in MS Access of compact and repair DB?

Thanks!