Forum Discussion

sato89's avatar
sato89
Icon for Helper I rankHelper 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

acabanchik's avatar
acabanchik
Icon for Advocate II rankAdvocate II
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

sato89's avatar
sato89
Icon for Helper I rankHelper 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