Integrate SSRS reports
Source dashboard reports from SSRS reports.
We are actively working on integrating SSRS reports into Power BI. SSRS is a very rich platform with huge array of extensibility options that customers are heavily using. So running these reports on prem and delivering the results to Power BI dashboard tiles is one option that we are exploring as a first step. If you have any inputs/suggestions, please comment on it.
David Vinson commented
Seriously - this should be second nature - I should at least be able to create an atomsvc file with SSRS reports and import them directly into PowerBI. To make it truly seamless, it would be great to be able to import the SSRS report definition into PowerBI as a start for a template for a data model. Please update ASAP
Andrea Landwehr commented
Ever going to happen? updates please!!!!
I can pull data from SSRS, Inside Excel 2013. I need the same option Inside Power BI Desktop
Planned for 2.5 years now. Is this ever going to come?
Filious Louis commented
For those who don't want to have an on-prem solution, it'd be nice to have the option of publishing SSRS reports directly to Power BI Service.
After installing powerBI for SSRS server and creating new PowerBIReportSever database
And Installing Power BI for report server with no issue
When I try to save the file into report serve I'm getting Server is not reachable
What is the correct path? I do have an instance ServerName\Dev2016 and my database is PowerBIReportServer
can please provide the steps for integration of ssrs reports to power bi reports.
We need to drill across from Power BI to an SSRS report
We need the ability to connect Power BI on SSRS on prem using a regular SQL Server DB. Is that on the roadmap?
Luis Simões commented
Most of the SSRS requirements I have been facing on customers is the hability to have a better support in a table format (usually with the intent to supply a data source for other systems/analysis). Another requirement usually seen is the hability to migrate reports existing in other platforms such as Microstrategy or others to a report like format that can be subscribed and received in email every day.
It would be a great feature if for example, apart from Dashboards, Reports, Excel files etc... we had a possibility to define Data Exports (using the existing models extract data to local files or email attachments either in csv or excel).
It would be helpful if you could share the planned roadmap for SSRS and Power BI integration.
any update on this?
Gaston Cruz commented
Please share a roadmap to SSRS and Power BI integration. A brief review of features and not only a possible Mid 2017 date!
Raphael Nash commented
I would like to get rid of my SSRS server and publish all my SSRS reports as is to the PowerBI service. One stop shopping for all my reports. The PowerBI service should be able to have most of the features as the SSRS on-prem offering such as running queries directly against my sql server on prem sql server and subscriptions from SSRS reports in power bi just like the on-prem SSRS server.
Balachandar Gopal commented
it would be great if Power BI's Q&A feature searches SSRS reports datasets to if any SSRS report is pinned in a dashboard. So user can get quick summaries from very large reports.
And the reverse would be good: Allowing us to run SSRS reports in the cloud like Power BI. Not everyone needs to run everything locally. Some want to do it all in the cloud - SSRS included. Gateway will need to support this as well, since SSRS reports may (like Power BI) go againt on-prem data sources.
I agree that PowerBI needs the ability to "drill across" from a graphic to an SSRS report (passing parameters where needed).
any update on this?
Please support kerberos authentication for the double hop scenario
P Ell commented
It would be nice to render PowerBI pbix files on the portal as well as to be able to refresh the model from the Reporting portal.