cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
sato89 Regular Visitor
Regular Visitor

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 also the following questions:

- Which licence of SQL Server allows me to add the licenced Reporting Services? Can SQL Server Standard Edition allow me in this purpose?

- If I've SQL Server Standard Edition installed, what kind of licence can I install of Reporting Services?

- What's the difference beetwen install Reporting Services to publish PowerBI reports and install Power BI Server for the same purpose? Are they the same features or not? Which would be the best way nowadays? Consider that now I'm working with Power BI Desktop (August 2018) to design the reports.

 

Thank you in advance.

 

Salvatore

2 ACCEPTED SOLUTIONS

Accepted Solutions
acabanchik Frequent Visitor
Frequent Visitor

Re: Reporting Services and Power BI reports on SQL Server 2017

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

View solution in original post

Highlighted
acabanchik Frequent Visitor
Frequent Visitor

Re: Reporting Services and Power BI reports on SQL Server 2017

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

View solution in original post

3 REPLIES 3
acabanchik Frequent Visitor
Frequent Visitor

Re: Reporting Services and Power BI reports on SQL Server 2017

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

View solution in original post

sato89 Regular Visitor
Regular Visitor

Re: Reporting Services and Power BI reports on SQL Server 2017

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

Highlighted
acabanchik Frequent Visitor
Frequent Visitor

Re: Reporting Services and Power BI reports on SQL Server 2017

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

View solution in original post

Helpful resources

Announcements
Ask Amir Anything

Exclusive LIVE Community Event No. 2 – Ask Amir Anything

Next in our Triple A series: Ask Amir Netz questions about the latest updates, features and future.

October 2019 Community Highlights

October 2019 Community Highlights

October was a busy month in the community. Read the recap article to learn about some of the events and content.

New Solution Badges

New Solution Badges

Two waves of brand new solution badges are coming! Read the article for more information on our new community badges.

Analytics in Azure virtual event

Analytics in Azure virtual event

Experience a limitless analytics service built to ingest, prep, manage, and serve data for immediate use in Power BI.

Users Online
Currently online: 191 members 2,200 guests
Please welcome our newest community members: