Skip to main content

Power BI

Under Review

SSRS Reports for drill down into detailed reports

Vote (1041) 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.

Administrator on 10 Jul 2020 16:04:38

We're working on URL parameters for Paginated Reports in Power BI that would enable this scenario for users, and expect it to land soon. We will update the status here once it is released publicly. Thanks!

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

51b2300f f4f2-413f-9b9e-20b6d80e7888 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

1afb5152 6d67-40fd-8ef9-451a25719d09 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

06fa94df d691-4b4f-b77f-de5d4dba2d8a 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

4ef379c6 c03e-443c-8150-e73bd00593ab 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

b39cb521 94b5-48f8-81ff-9cf730d3b8f7 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

f1a38e79 14f6-4846-b8f4-9d286b85fc34 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

c6232295 f04a-4920-8090-6424af5d178c 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

be27c81b cf9a-4814-98d7-01fba4e5fa34 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

5e58cb6d 75ef-486b-968a-656bc25608fd 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

9fd3880b c21d-4f9e-98c0-adb16715fb61 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