Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
skarthick6
New Member

Power BI Server Installation Preq-Requisites

Hi, in order to install PBI Report Server, is SQL Server Enterprise being installed a pre-requisite!?

Because, in order to use PBI Report Server, we just need SQL Server Enterprise license to be available with the company. Right? we dont need to have it installed  - is my assumptions. Please help confirm.

1 ACCEPTED SOLUTION
jcollinson2001
Resolver IV
Resolver IV

I asked a similar question when looking at installing PBIRS. The answer was that PBIRS has to be installed on the same server (physical or virtual) that is running SQL Server EE. Here's the official response:

 

  • This sparked some internal digging to find the definitive answer – which unfortunately is “no”

 

  • PBIRS (licensed under your existing SQL EE with SA) is the same as the other components in the SQL Server stack (SQL, SSRS, SSAS, etc) – they are indivisible from a licensing perspective.
  • You can install PBIRS on your existing SQL host at zero extra cost.
  • But if you want to install it on a separate/dedicated server you’ll need to (SQL Server) license that host separately – just like if you wanted to install Analysis Services or traditional SSRS on a dedicated server.

Here's the clause from the licensing terms which confirms this:

 

4.6 Use of Power BI Report Server – SQL Server Enterprise Edition

Customer may run Power BI Report Server software on the Licensed Server. Customer may run the software on a maximum numbers of cores equal to the number of SQL Server Enterprise Edition Core Licenses with active SA assigned to that Server, subject to a minimum of four cores per OSE. Use is additionally subject to the applicable terms of Customer’s volume license agreement. A Power BI Pro User SL is required to publish shared Power BI reports using the Power BI Report Server. This right expires upon expiration of Customer’s SA coverage. 

View solution in original post

2 REPLIES 2
jcollinson2001
Resolver IV
Resolver IV

I asked a similar question when looking at installing PBIRS. The answer was that PBIRS has to be installed on the same server (physical or virtual) that is running SQL Server EE. Here's the official response:

 

  • This sparked some internal digging to find the definitive answer – which unfortunately is “no”

 

  • PBIRS (licensed under your existing SQL EE with SA) is the same as the other components in the SQL Server stack (SQL, SSRS, SSAS, etc) – they are indivisible from a licensing perspective.
  • You can install PBIRS on your existing SQL host at zero extra cost.
  • But if you want to install it on a separate/dedicated server you’ll need to (SQL Server) license that host separately – just like if you wanted to install Analysis Services or traditional SSRS on a dedicated server.

Here's the clause from the licensing terms which confirms this:

 

4.6 Use of Power BI Report Server – SQL Server Enterprise Edition

Customer may run Power BI Report Server software on the Licensed Server. Customer may run the software on a maximum numbers of cores equal to the number of SQL Server Enterprise Edition Core Licenses with active SA assigned to that Server, subject to a minimum of four cores per OSE. Use is additionally subject to the applicable terms of Customer’s volume license agreement. A Power BI Pro User SL is required to publish shared Power BI reports using the Power BI Report Server. This right expires upon expiration of Customer’s SA coverage. 

Anonymous
Not applicable

I know that this is an older post, but have there been any changes to these install rules over the last 2+ years?

 

Is there any change to the 'This sparked some internal digging to find the definitive answer – which unfortunately is “no” '  answer?

 

Thanks,

CB

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel1

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.