How can we improve Power BI?

Integrate SSRS reports

Source dashboard reports from SSRS reports.

1,665 votes
Sign in
Check!
(thinking…)
Reset
or sign in with
  • facebook
  • google
    Password icon
    I agree to the terms of service
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Jeremiah Harrell shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →
    planned  ·  Mey Meenakshisundaram responded  · 

    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.

    95 comments

    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      I agree to the terms of service
      Signed in as (Sign out)
      Submitting...
      • Anonymous commented  ·   ·  Flag as inappropriate

        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.

      • Anonymous commented  ·   ·  Flag as inappropriate

        Power BI should be the access point for all reports, including ssrs paginated reports

      • John Guilbert commented  ·   ·  Flag as inappropriate

        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  ·   ·  Flag as inappropriate

        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  ·   ·  Flag as inappropriate

        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

      • Anonymous commented  ·   ·  Flag as inappropriate

        I can pull data from SSRS, Inside Excel 2013. I need the same option Inside Power BI Desktop

      • Filious Louis commented  ·   ·  Flag as inappropriate

        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.

      • Anonymous commented  ·   ·  Flag as inappropriate

        hi there,

        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

        Thanks,
        Oded Dror

      • lakshmi commented  ·   ·  Flag as inappropriate

        can please provide the steps for integration of ssrs reports to power bi reports.

      • Scott commented  ·   ·  Flag as inappropriate

        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  ·   ·  Flag as inappropriate

        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).

      • Joviee commented  ·   ·  Flag as inappropriate

        It would be helpful if you could share the planned roadmap for SSRS and Power BI integration.

      ← Previous 1 3 4 5

      Feedback and Knowledge Base

      Ready to get started?

      Try new features of Power BI today by signing up and learn more about our powerful suite of apps.