Turns out we had installed SQL 2012 but not SQL 2012 SP1. Power View gets a number of important upgrades in SP1, including much-needed filtering that’s missing from the earlier version, as well as my eagerly anticipated Map chart type.
In order to upgrade our SharePoint 2010/SQL 2012 installation to SQL 2012 SP1, we needed to do the following:
1. Install SQL 2012 Server SP1.
2. Install Microsoft® SQL Server® 2012 SP1 Reporting Services Add-in for Microsoft® SharePoint®.
3. Rerun the PowerPivot Configuration tool. (Note: After the SQL 2012 SP1 upgrade there will be an additional PowerPivot configuration tool installed specifically for SharePoint 2013; be sure to use the original tool instead.)
And with that…maps!!!