Skip to main content
Microsoft Idea

Power BI

Completed

SSRS Reports for drill down into detailed reports

Vote (1064) Share
Dan Umstattd's profile image

Dan Umstattd on 19 Nov 2014 21:52:08

I think using SSRS type of reports to show detailed information that make up measures dispalayed on the dashboard would be useful. Currently I do that in performance point using actions from my tabular models. I think if that was included this would be a full replacement to performance point.

Chris Finlan (administrator) on 18 Mar 2021 19:06:55

We released URL parameter support for this scenario in the summer of 2019.  In addition, the new paginated report visual coming soon will allow additional options to drill into your data in a paginated report directly inside you Power BI report with a paginated report.

Comments (25)
Dan Umstattd's profile image Profile Picture

Power BI User on 05 Jul 2020 22:59:17

RE: SSRS Reports for drill down into detailed reports

Drill down - adding this feature would a plus point !

Dan Umstattd's profile image Profile Picture

Paul Turley on 05 Jul 2020 22:52:47

RE: SSRS Reports for drill down into detailed reports

Will, I think it's important to acknowledge that this is a feature request that would be a game-changer for enterprise deployments and adoption, but will likely not get votes from novice or self-service-only users. Please consider that when ranking and prioritizing feature requests.

Dan Umstattd's profile image Profile Picture

Mike W on 05 Jul 2020 22:48:12

RE: SSRS Reports for drill down into detailed reports

We could sell a lot more Power BI if we had this functionality. Any update on adding this functionality?

Dan Umstattd's profile image Profile Picture

rgoerwit on 05 Jul 2020 22:32:04

RE: SSRS Reports for drill down into detailed reports

This idea has popped up in several SSRS-related suggestions. The basic point is that many of us want a way to drill down/across from analytical reports to SSRS-based "detail" reports. We'll need a way to specify an SSRS report or server and pass parameters from PowerBI to SSRS. It could be implemented as an extra item grouped together with ...->"Eport Data"

Dan Umstattd's profile image Profile Picture

sreinman on 05 Jul 2020 22:28:56

RE: SSRS Reports for drill down into detailed reports

Would like to see a dynamic URL or Report action from Power BI that can take the user to an SSRS report for a drill down based on the filters that are applied to Power BI report

Dan Umstattd's profile image Profile Picture

Deena Power BI User on 05 Jul 2020 22:28:48

RE: SSRS Reports for drill down into detailed reports

Absolute must to bring Power BI inline with other analytical tools. Please review and provide and update.

Dan Umstattd's profile image Profile Picture

David Botz on 05 Jul 2020 22:21:12

RE: SSRS Reports for drill down into detailed reports

Take the Report Actions from SSAS models.

Dan Umstattd's profile image Profile Picture

Mukesh Singh on 05 Jul 2020 22:17:57

RE: SSRS Reports for drill down into detailed reports

SSRS - Drill Down Report
Drill-down describes an increasing granularity in the management of data with comfortable functions for navigating through the data where user is capable to jump to the next level of detail or the next report object on the same level, hide individual levels and switch between the detail and drilldown data information.
http://www.sql-datatools.com/2015/06/microsoft-drilldown-ssrs-report.html

Dan Umstattd's profile image Profile Picture

Andy on 05 Jul 2020 22:12:37

RE: SSRS Reports for drill down into detailed reports

In order to drill down into SSRS we need to be able to pass parameters

Dan Umstattd's profile image Profile Picture

Power BI User on 05 Jul 2020 22:09:25

RE: SSRS Reports for drill down into detailed reports

This is a key feature that is preventing me from putting a stamp of approval and start to use it