PowerView – unable to ‘Pin’ Filter

I’ve been working with a client who has been generating some impressive PowerView reports using SharePoint 2010 and a SQL 2012 Analysis Services cube (Multidimensional instance). Everything was working fine until I was posed the question ‘any idea why I don’t have the ability to pin filters’ in PowerView?

After raising this with some colleagues, it transpired that this missing element was addressed in SQL 2012 SP1 Cumulative Update 4. But don’t be fooled into thinking this means that the CU has to be applied to the SQL 2012 Analysis Services instance, this update is applicable to the SSRS Add-in, which should be installed across all of your SharePoint Web Servers. PowerView is part of the SQL Server Reporting Services family and therefore, this ‘pin’ facility, is part of the Add-in.

Download to SQL 2012 SP1 CU4 :


Once updated, your Add-in should display the following version number: 11.1.3368.0



Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s