Saving data from PowerPivot

Question

Hi

I've been using PowerPivot to combine data from a variety of sources (CSV files) to create a single list of several millions. I have used Powerpivot because I can't open the source CSV files in Excel 2010 as it only opens files with just over a million rows (so I can't view the data). Anyway, now I've compiled the data I want to use in PowerPivot I need to save it in CSV format and password protect it. But when I try to 'save as' and try to select 'csv' format it doesn't save the data. (E.g. the CSV file is empty and does not contain the list I have created in PowerPivot).

 

I've scoured the help files but cannot find how to do this. Any help would be appreciated.

 

Regards

 

Dave

Answer 1

 

Hi David,

 

Exporting or save as to a CVS file is not a scenario that PowerPivot support at the moment. The Save As CVS file performs the default Excel 2010 functionality and not the PowerPivot add-in, that is, it's not aware of and does not know how to communicate with PowerPivot's VertiPag in-memory engine (that handles the millions of data). Saving as CVS file it will save the data in the active Excel sheet, but not the data that is stored in the vertipaq in-memory engine.

If this workbook is stored in a SharePoint site with PowerPivot for SharePoint, you may use it as a data source for other BI applications and you can handles security using SharePoint features.

Hope that helps,

Mariano

---

Mariano Teixeira Neto Analysis Services SQL Server BI Microsoft Corp.