PowerPivot and Dax Tips
Filters
Title Filter
Display #
5
10
15
20
25
30
50
100
All
Filter
List of articles in category PowerPivot Tips
Title
Author
To regenerate thumbnail in the PowerPivot gallery change on of the files property (example: Title) and save that change.
Written by Dave Wickert
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
Written by Dave Wickert
If your goal is to show PowerPivot charts to their best effect in the SharePoint PowerPivot Gallery, then Hide those chart data sheets
Written by Russell Christopher
Use a fixed port# (for example 55000) for SharePoint Central Admin
Written by Dave Wickert
Always navigate to the upper left-hand cell (A1) prior to saving the PowerPivot workbook
Written by Dave Wickert
You cannot add new rows into a PowerPivot table, You can only add new columns of data.
Written by Microsoft
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
Written by Microsoft
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.
Written by Microsoft
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.
Written by Microsoft
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".
Written by Vidas Matelis
Page 2 of 3
1
2
3
2007-2015 VidasSoft Systems Inc.