Forum Discussion

Namnami's avatar
Namnami
Regular Visitor
9 years ago

Power BI and SSRS

We currently have SSRS 2008 R2 and Sharepoint performance point dashboard using SSAS 2005 cube. We want to start using power BI (mainly instead of the performance point dashboard).   What is the r...
Report Server
SSAS
SSRS
v-qiuyu-msft's avatar
v-qiuyu-msft
Icon for Community Support rankCommunity Support
9 years ago

Hi Namnami,

 

Power BI Report Server combines the self-service BI capabilities of Power BI Desktop and Power BI reports with the enterprise reporting capabilities of SSRS.

 

You can find the minimum hardware and software requirements to install and run Power BI Report Server from here. Also Power BI reports only support SSAS live connection, which requires SSAS server is 2012 SP1 CU4 or later Business Intelligence and Enterprise SKU. Publishing PBIX reports from Desktop will require a Pro License for production usage.

 

When saying report server, generally it means SSRS. Power BI report server is a specific report server, and is available as part of Power BI Premium and compatible with SSRS reports, allowing the deployment and distribution of interactive Power BI reports—and traditional paginated reports—on-premises within the boundaries of an organization's firewall. Organizations can choose Power BI in the cloud, or elect to keep reports on-premises with Power BI Report Server and move to the cloud at their pace.  

 

You can get started to learn more about Power BI report server from official document here.

 

Best Regards,
Qiuyun Yu

rchilambi's avatar
rchilambi
New Member
8 years ago

Hi,

My question is can i publish power bi report generated using power bi desktop to SSRS (version 2016)?  If so i wouldn't need power bi server - correct??

 

Rajesh

 

  • muchinski's avatar
    muchinski
    Icon for Resolver II rankResolver II
    8 years ago

    Hi,

     

    you can save Power BI files on Report Server 2016 (SSRS), but the SSRS will not render them on browser or update the data model. The only option available will be to download the report and open again on Power BI Desktop.

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Hi muchinski,

       

      I have some reports created with SSRS. Is it possible that I could keep the old reports and use the Power BI report server at same time? Do I need to uninstall the old report server and install the Power BI report server to make it work? Thanks