tip
To regenerate thumbnail in the PowerPivot gallery change on of the files property (example: Title) and save that change.
Two tips from "the Old Country"
Use a fixed port# (for example 55000) for SharePoint Central Admin
When creating data connection, specify data or file locations in a format that is accessible over a network connection. An HTTP URL or a shared folder (such as \\srvName\ShareName\FileName) are examples of locations that can be accessed from either a clie
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"
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
Windows 7 is only supported for PowerPivot for Excel; Windows 7 is not a supported OS for PowerPivot for SharePoint
You can allow non-administrator users to log on to your domain controller through remote desktop by changing windows GPO permissions
You can hide a table in the PowerPivot field list by marking ALL its fields as "Hide in Pivot".
You cannot add new rows into a PowerPivot table, You can only add new columns of data.
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
You should consider learning Data Analysis Expressions (DAX) language. Using DAX is necessary if you want to build relational queries or custom data manipulation in the PowerPivot data you assemble in the workbook.
- 1
- 2