Selected Tags:

tip
Available Tags: connection, dax, design, excel, faq, install, load, performance, setup, sharepoint, v2, video
Title Author Date
Gemini (PowerPivot)- Copy/Paste T.K. Anand 10/14/2009
To reduce memory consumption load into PowerPivot just fields that will be used by Pivot table reports or by PowerPivot joins/calculations. Vidas Matelis 11/08/2009
Some fields are loaded into PowerPivot, but are not used in the pivot reports. Hide them in the PowerPivot by selecting column and then choosing menu "Hide columns"->"From Pivot table". Vidas Matelis 11/08/2009
The 64-bit versions of Excel and the PowerPivot add-in will support significantly more data than the 32-bit versions. You must use the 64-bit versions if you are importing more than one million rows or columns of data. Microsoft 11/10/2009
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. Microsoft 11/10/2009
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 Microsoft 11/10/2009
You cannot add new rows into a PowerPivot table, You can only add new columns of data. Microsoft 11/10/2009
Always navigate to the upper left-hand cell (A1) prior to saving the PowerPivot workbook Dave Wickert 11/19/2009
Use a fixed port# (for example 55000) for SharePoint Central Admin Dave Wickert 11/20/2009
If your goal is to show PowerPivot charts to their best effect in the SharePoint PowerPivot Gallery, then Hide those chart data sheets Russell Christopher 11/21/2009
Import Filters in PowerPivot Robert C. Cain 11/24/2009
If you are going to change a server’s static IP address after you have installed SharePoint 2010, please remember to reboot the server to make the new address become recognized. An ‘iisreset’ isn’t good enough Dave Wickert 12/02/2009
To regenerate thumbnail in the PowerPivot gallery change on of the files property (example: Title) and save that change. Dave Wickert 12/11/2009
Clear out SharePoint server local cache from the folder c:\windows\temp\WebTempDir or aim the local cache to another folder Denny Lee 01/06/2010
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 01/06/2010
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 01/10/2010
Make your PowerPivot on SharePoint “view only” Kasper de Jonge 03/04/2010
Windows 7 is only supported for PowerPivot for Excel; Windows 7 is not a supported OS for PowerPivot for SharePoint Dave Wickert 03/06/2010
Add a new Pivottable or Pivotchart and reuse the slicers of an existing PowerPivot workbook Kasper de Jonge 03/19/2010
Q: How can I change connection information (server name, DB name, etc) for existing PowerPivot table? PowerPivot-Info.com 03/24/2010
Q: My PowerPivot table was loaded from the SQL Server table that recently was changed. How can I apply these source table changes to PowerPivot table? PowerPivot-Info.com 03/24/2010
You can allow non-administrator users to log on to your domain controller through remote desktop by changing windows GPO permissions Dave Wickert 04/08/2010
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 05/14/2010
You can hide a table in the PowerPivot field list by marking ALL its fields as "Hide in Pivot". Dave Wickert 05/14/2010
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 06/25/2010
Tips and Tricks for Troubleshooting a Microsoft SQL Server PowerPivot for SharePoint Installation Dave Wickert 06/25/2010
PowerPivot field list and Excel field list at same time! Rob Collie 06/27/2010
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 10/04/2010
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 10/04/2010
PowerPivot Tips and Tricks - First Findings webadmin 11/22/2010
PowerPivot: improve the performances by sorting tables Alberto Ferrari 04/15/2011
Two tips from "the Old Country" Rob Collie 06/11/2011
PowerPivot Nuggets Frederik Vandeputte 08/18/2011
 

Pyramid+PowerPivot