SSRS Reports for drill down into detailed reports
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.
Thanks for the suggestion! We’ll consider it along with the others here and prioritize it based on the votes. If you want to help raise the priority, keep voting!
Data Muncher commented
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.
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
Robert Blatchford commented
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.
Diana Schnuth commented
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!
Drill down - adding this feature would a plus point !
Paul Turley commented
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.
Mike W commented
We could sell a lot more Power BI if we had this functionality. Any update on adding this functionality?
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"
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
Absolute must to bring Power BI inline with other analytical tools. Please review and provide and update.
Take the Report Actions from SSAS models.
Mukesh Singh commented
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.
In order to drill down into SSRS we need to be able to pass parameters
This is a key feature that is preventing me from putting a stamp of approval and start to use it
suhail ali commented
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
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!
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. :)
Rafal Lukawiecki commented
...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.