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

9b47e4b6 d1f1-4f95-a0a5-246d1a97b4fa on 06 Jul 2020 00:07:42

RE: SSRS Reports for drill down into detailed reports

I wrote a blog about this..

https://www.sqlfrank.com/2020/02/04/powerbi-drilldown-to-ssrs-detail-report/

Dan Umstattd's profile image Profile Picture

93093d37 2b30-4cd1-a5fc-733d93d1bf4c on 06 Jul 2020 00:04:09

RE: SSRS Reports for drill down into detailed reports

What about on Power BI ?

Dan Umstattd's profile image Profile Picture

fcce559a 1f75-49f8-82bd-de40d6bbe0e8 on 05 Jul 2020 23:53:28

RE: SSRS Reports for drill down into detailed reports

Does it allow to choose the rendering format like HTML/xml and etc as same as ssrs?

Dan Umstattd's profile image Profile Picture

322628fa a09f-4028-89a5-bf2c318e69dd on 05 Jul 2020 23:53:24

RE: SSRS Reports for drill down into detailed reports

This is fantastic that it is started and will be a welcome addition to the overall solution.

Dan Umstattd's profile image Profile Picture

a3309361 99be-ea11-a812-000d3a8ddfb2 on 05 Jul 2020 23:53:22

RE: SSRS Reports for drill down into detailed reports

absolutely needed, everyone else reiterated what I would say, pass parameters, identity if you can, etc.

Dan Umstattd's profile image Profile Picture

14380ac8 5952-434d-b33a-92e5d53cfc33 on 05 Jul 2020 23:43:05

RE: SSRS Reports for drill down into detailed reports

This is critical for enterprise adoption. Dashboards tell a good story, but the drill thru to SSRS would provide the WHY.

Dan Umstattd's profile image Profile Picture

ef3d7858 ad19-41c2-aefd-406b92dbd05d on 05 Jul 2020 23:26:15

RE: SSRS Reports for drill down into detailed reports

Absolutely necessary, one of the most common requests at the company I work for.
Many times, users have to go back to the ERP system to manually run a report, where they manually enter all the different filters they had already applied in powerbi only to retrieve and be able to share the underlying data in a proper format that can be printed as a document.

Dan Umstattd's profile image Profile Picture

5bcefd88 727f-4c3b-bf01-42317d5422b8 on 05 Jul 2020 23:12:32

RE: SSRS Reports for drill down into detailed reports

This is absolutely vital for enterprises - SSRS complements Power BI - it can answer the "why?" questions that are simply less friendly in a Power BI table/matrix

Dan Umstattd's profile image Profile Picture

1779fd58 ef9b-4672-b729-c55a5301fb34 on 05 Jul 2020 23:11:03

RE: SSRS Reports for drill down into detailed reports

I'd like to add my support to this feature. We are an enterprise user, implementing a Performance and Operational Monitoring dashboard for our mobile workforce. We need to be able to drilldown to the type of detailed reports that SSRS is ideal for. We need a hybrid solution to use the best of both products. I should say we need this in the On-Prem Report Server environment as data governance stops us using the Cloud.

Dan Umstattd's profile image Profile Picture

446f1a49 f54f-4225-8912-ae7f35d4ed46 on 05 Jul 2020 23:01:15

RE: SSRS Reports for drill down into detailed reports

This idea has a goodly amount of votes. Could we get an update on where it stands in the review process? It would be helpful to know if and when we could plan on this option being available for future project planning, as it truly would be a game-changer for the user experience (especially in tandem with allowing paginated reports to be visible in the Power BI mobile app, which is a different suggestion that also has a decent amount of votes).

Thanks for your consideration!