Thursday, December 30, 2010 6:20 PM
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.
Thursday, December 30, 2010 10:32 PM
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 Teixeira Neto Analysis Services SQL Server BI Microsoft Corp.
- Marked As Answer by Jinchun ChenMicrosoft Employee, Moderator Monday, January 10, 2011 2:34 AM