How to drill-through from a Datazen dashboard to Power View in SharePoint

Christopher Finlan

Welcome to the new blog home everyone!

So I’m assuming (perhaps incorrectly) most folks reading this know you can setup drill-through to a custom url in Datazen. Usually, I talk to folks about it in the context of drilling through to a traditional SQL Server Reporting Services report, and I’m passing through some parameters I’ve selected on my Datazen dashboard. But did you know you could also do something similar to a Power View report in SharePoint 2013? Well you can!

First, you need to make sure you have Cumulative Update 4 for SQL Server 2012 SP1 applied in your SharePoint instance. This update introduced the ability to use filters in a Power View URL. The filters act as “pinned filters”, meaning they will apply to your entire report. Assuming that is done, the process is fairly straightforward –

1. You’ll need to create a Power View…

View original post 373 more words