If you have attempted to install the Powerpivot Add-in for Excel 2010 and you notice the PowerPivot tab is not there after install, chances are the addin failed to load. You may also notice an error along the lines of “runtime error occurred during the loading of the COM add-in”. In Excel 2013 […]
Mosdal is not the name of the Android in the current Star Trek film, rather it is a support kit useful for troubleshooting issues with Microsoft Online Services. Try it here … a quick download and install on your local PC, then enter your Microsoft Online account, perform your intended operations, then wait a few […]
Thats what I was after ! Not so obvious in the INFORMATION.SCHEMA tables but this query will list all the foreign keys in the database along with their associated primary keys. Thanks to … http://wiki.lessthandot.com/index.php/Find_all_Primary_and_Foreign_Keys_In_A_Database
Backing up and restoring to multiple files can make your admin activities faster and can also test the throughput of your storage if you want to go silly. A sample backup command sample for backing up and restoring 2 files is outlined below : Now run the following query to kill all connections in the destination […]
You have a list of data and you want to remove duplicates in Excel before importing into PowerPivot. There are two approaches that will give you the same visual result, but only one that will suit PowerPivot. 1. Advanced Filter – Filter Unique Rows, this is only a visual filter so the full list […]
Golden link = this PowerPivot FAQ site http://powerpivotfaq.com/Lists/TGPPF/AllItems.aspx !! Includes posts by Rob Collie who authored this cool read http://www.amazon.com/DAX-Formulas-PowerPivot-Excel-Mastering/dp/1615470158 (at a cool $10 Kindle price). Note – this PowerPivot FAQ is a public Sharepoint site so you are browsing the site as an external user – speaking of which, see my post on Sharepoint 2013 […]
There are plenty of examples around about how to calculate working days for a single Public Holiday calendar. But what happens when the Public Holidays vary by state ? This post walks through a PowerPivot example for calculating a single measure “Working Days” that works when the states each have their own distinct […]
When you are working with Excel Linked Tables as data sources for PowerPivot, you may notice that the name you labelled the table name (in Excel) has not imported into the PowerPivot data model as you expected. Instead you might see the name “Tablexx” where xx is a number rather than the custom name you […]
Those integrating Reporting Services with Sharepoint 2013, note you need the 2012 SP1 add-in for this to be successful. Otherwise you may find your Sharepoint Powershell commands Install-SPRSService and Install-SPRSServiceProxyCommands won’t work. http://msdn.microsoft.com/en-us/library/gg492257.aspx Happy Days !
An excellent concise summary of the feature differences between the editions of the new Sharepoint 2013 http://talbottcrowell.wordpress.com/2012/11/27/whats-new-in-sharepoint-2013-editions-comparison/. Note Business Intelligence still requires Enterprise edition but some interesting changes to the definition of internal vs external users with the former requiring license CALs and the latter not… http://www.degdigital.com/blog/big-changes-in-sharepoint-2013-licensing-for-portal-clients/.