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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

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
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.