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

suhail ali 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

DAR 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

Bjoern 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

Renita 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

Rafal Lukawiecki 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.