How can we improve Power BI?

Integrate SSRS reports

Source dashboard reports from SSRS reports.

1,573 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 HarrellJeremiah Harrell shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →
    planned  ·  Mey MeenakshisundaramMey 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.

    87 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...
      • David VinsonDavid 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 LouisFilious 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

      • lakshmilakshmi commented  ·   ·  Flag as inappropriate

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

      • ScottScott 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õesLuis 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).

      • JovieeJoviee commented  ·   ·  Flag as inappropriate

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

      • Gaston CruzGaston Cruz commented  ·   ·  Flag as inappropriate

        Please share a roadmap to SSRS and Power BI integration. A brief review of features and not only a possible Mid 2017 date!

      • Raphael NashRaphael Nash commented  ·   ·  Flag as inappropriate

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

        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.

      • rgoerwitrgoerwit commented  ·   ·  Flag as inappropriate

        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.

      • RyanRyan commented  ·   ·  Flag as inappropriate

        I agree that PowerBI needs the ability to "drill across" from a graphic to an SSRS report (passing parameters where needed).

      • P EllP Ell commented  ·   ·  Flag as inappropriate

        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.

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