On Oct 26, 2013 I presented at “Big Data Saturday” event in Toronto, Canada. Here I am posting my session key points and notes.
Power Pivot Database
- Make a copy of your workbook and change extension from .xlsx to .zip. Inside zip file in the folder “xl\customData” there is file item1.data that is backup of Power Pivot database.
- When Power Pivot engine starts it restores database backup on your machine in the folder %temp%. Power Pivot will create sub-folder “Vertipaq_<GUID>” where in .db sub-folder you will find folder for each table in your model. Tip – go into biggest table folder, order files by size and see if you really need columns that use most of the space.