PowerPivot and Dax Tips

List of articles in category PowerPivot Tips
Title	Author
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	Written by Dave Wickert
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"	Written by Dave Wickert
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).	Written by Marius Dumitru
You can hide a table in the PowerPivot field list by marking ALL its fields as "Hide in Pivot".	Written by Dave Wickert
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	Written by Dave Wickert
You can allow non-administrator users to log on to your domain controller through remote desktop by changing windows GPO permissions	Written by Dave Wickert
Windows 7 is only supported for PowerPivot for Excel; Windows 7 is not a supported OS for PowerPivot for SharePoint	Written by Dave Wickert
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	Written by Kasper de Jonge
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	Written by Denny Lee
Clear out SharePoint server local cache from the folder c:\windows\temp\WebTempDir or aim the local cache to another folder	Written by Denny Lee

Page 1 of 3