Forum Discussion

sato89's avatar
sato89
Helper I
7 years ago
Solved

Reporting Services and Power BI reports on SQL Server 2017

Hi everyone, I have a server with a SQL Server 2017 installed. I want to know if it's possibile to use the product key of the installed SQL Server to install SQL Reporting Services. However, I have...
power bi
Reporting Licences
reporting services
  • acabanchik's avatar
    acabanchik
    7 years ago

    Hi

    Both SQL Server EE or Std allow SSRS to be installed

     

    Power BI Report Server, is a superior version because you can publish reports of PBI.

     

    Now the licensing of Power BI Report Server requires
    - SQL Server EE + Software Assurance
    or
    - Power BI Premium

     

     

    best regards

  • acabanchik's avatar
    acabanchik
    7 years ago

    Hi

     

    Power BI Report Server does not include SQL EE.
    But, it can require and install components such as Analysis Services (not visible), and like SSRS require a SQL server (2008 or more) for catalogs and task planning

sato89's avatar
sato89
Helper I
7 years ago

Thank you for your answer.

One last dubt:

Does Power BI Server Premium Edition contain SQL Server Enterprise inside the installation?

I saw that to set a scheduled refresh of data into a report with Power BI Server, you must have SQL Server Agent active and it feature isn't available in the SQL Server Express Edition.

 

Thank you in advance.

 

Salvatore

acabanchik's avatar
acabanchik
Advocate II
7 years ago

Hi

 

Power BI Report Server does not include SQL EE.
But, it can require and install components such as Analysis Services (not visible), and like SSRS require a SQL server (2008 or more) for catalogs and task planning