PowerPivot Tips
   Display # 
# Article Title Author
1 SharePoint has a new high severity health rule for SharePoint 2010 that raises an error if your machines does not have 2X the amount of physical memory in free disk space Dave Wickert
2 When specifying your query for importing data into PowerPivot, make sure you columns are unique and only returned once in the query! Otherwise error "Cannot load preview for table "summary1" Dave Wickert
3 It’s always a best practice to avoid filtering an entire table if the filter condition involves only some of the table columns (i.e. when no key/unique columns are used in the condition expression). Marius Dumitru
4 You can hide a table in the PowerPivot field list by marking ALL its fields as "Hide in Pivot". Dave Wickert
5 You must use a 32-bit browser when running on a 64-bit client. Virtually every SharePoint feature and application, e.g. Excel, PPT, and Word Web Apps, do not support 64-bit browsers Dave Wickert
6 You can allow non-administrator users to log on to your domain controller through remote desktop by changing windows GPO permissions Dave Wickert
7 Windows 7 is only supported for PowerPivot for Excel; Windows 7 is not a supported OS for PowerPivot for SharePoint Dave Wickert
8 When you want to import different query’s from the same datasource reuse the same data source connection by selecting it from existing connection list Kasper de Jonge
9 SharePoint keeps all documents even after they are deleted within the SharePoint content database for up to 30 days. To fully delete SharePoint documents and free up space you need to delete them from 3 places Denny Lee
10 Clear out SharePoint server local cache from the folder c:\windows\temp\WebTempDir or aim the local cache to another folder Denny Lee
 
<< Start < Prev 1 2 3 Next > End >>
Page 1 of 3
 

Pyramid+PowerPivot