Power View: Where’s My Map?

After watching demos on Power View I was excited to begin using the tool, as we recently configured SQL 2012 SSRS and PowerPivot with SharePoint 2010 for an internationally-focused client. But after playing around with my PowerPivot model in Power View, I realized the Map chart type that I had been so looking forward to using…was not available.

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!!!

About Nick Ovuka

Nick is a Technical Project Manager with over 11 years experience in all aspects of custom software development focused on Microsoft Technologies. Since joining AIS in 2007, he has developed software for clients in a variety of industries including Health Care, Telecommunications, Legal, Finance and most recently Maritime Shipping. Nick has a BS in Integrated Science & Technology from James Madison University as well as many technical certifications.