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

65082c99 3ea7-47c9-aa95-ef7e3f4fa2f9 on 05 Jul 2020 22:04:12

RE: SSRS Reports for drill down into detailed reports

Baking in the drill-down right into the tabular model and allowing custom SSRS drill-down reporting would be ideal. Client tools should be able to query the model for drill-down metadata to provide for a great drill-down experience while customized drill-down reporting would be used to handle specific reporting requirements

Dan Umstattd's profile image Profile Picture

baf81854 207a-4d88-8543-4e0f254c57fc on 05 Jul 2020 22:02:27

RE: SSRS Reports for drill down into detailed reports

This is an excellent idea and should be considered a higher priority given the latest roadmap for sharepoint and the push to move to PowerBI. To compete with other products drill-down is a version 1 type of capability. This gets my vote to add!

Dan Umstattd's profile image Profile Picture

1e8f1ba7 3149-46fa-ae5a-668d7016c8e6 on 05 Jul 2020 22:01:43

RE: SSRS Reports for drill down into detailed reports

Yep, the drill-down functionality would be great. The very aggregated visuals are great, but if you want to deep-dive, you need more and more visuals, which makes it hard to observe. Please implement this feature! I agree with "Rafal Lukawiecki", but then at least integrate SSRS directly into a PBI-webserver, so both tools can be used simultaneously and seamless.

Personally I really don't like SSRS, as it feels & looks old and doesn't make fun. :)

Dan Umstattd's profile image Profile Picture

d6b98a87 7ecd-49d9-8514-30814293db83 on 05 Jul 2020 22:01:42

RE: SSRS Reports for drill down into detailed reports

Totally agree!!!

Dan Umstattd's profile image Profile Picture

d22ae05b fed7-4bd9-895a-4213657e88d4 on 05 Jul 2020 21:59:27

RE: SSRS Reports for drill down into detailed reports

...or a good drilldown/show data functionality that would allow for a seamless transition from an interactive dashboard/report into a table of more detailed rows. My enterprise customers often observe that "modern" visualisations do not think of traditional, paginated reports as useful. Boring-looking as they are, paginated reports are still extremely important, but it would be cool to integrate them better into a dashboard-driven workflow. If SSRS is the right tool, so be it. "Table" visualisation in Power View/BI is not sufficient and does not allow printing.