I just wrote a simple PowerShell script that iterates through PowerPivot temporary folders and calculates how much space each PowerPivot table is using. Could you please help me test this script?
To test:
- Open PowerPivot workbook
- Go to PowerPivot window
- Execute script in PowerShell.
I would like to know if this works for you or if you are getting any errors or unexpected results.
My Powershell script can be downloaded from here:
http://powerpivot-info.com/public_files/vertipaq.txt
Save text file as .ps1 file.
Thanks for your help!