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.
With Azure Data Factory now supporting SSIS, SSRS is the one gap in being able to move the full BI stack to a PaaS solution. Having support for paginated reports in the Power BI Service would fill that gap.
duc thai commented
any update it has been over 3 years
This would be good
Updates on this?
even just a name and a link to the ssrs report would be ok
Power BI should be the access point for all reports, including ssrs paginated reports
John Guilbert commented
Any update....come on. It's been a while lads. We are starting to get a lot of legacy SharePoint 2007 R2 with SSRS integration. We need support for this or at least advice on a suitable third-party tool who you are partnered with!
Jaco Ipsen commented
i vote for this as Connection a data feed from SSRS to a clients Power Bi is giving our customers a good options to create what ever they need :)
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?