Forum Discussion
Power BI Report Server Licensing
Hi,
I've read several articles on Power BI Report Server Licensing, but for my use case I'm a little confused. My use case is this:
I plan to upgrade from SQL Server Standard 2008 to SQL Server Standard 2016 later this year. If I want to use Power BI Report Server do I have to buy a Power BI Premium license, or can I download and run Power BI Report Server alongside or as a replacement for SSRS based on the licenses I purchase for SQL Server Standard 2016
Alternatively, can I use Power BI Pro Service and publish content for consumers with the understanding each consumer must also have a Power BI Pro License?
I plan to upgrade from SQL Server Standard 2008 to SQL Server Standard 2016 later this year. If I want to use Power BI Report Server do I have to buy a Power BI Premium license, or can I download and run Power BI Report Server alongside or as a replacement for SSRS based on the licenses I purchase for SQL Server Standard 2016
You have two options.
You can buy Power BI Premium, this allows you to license the same number of cores that you purchase in capacity in the premium license on premises for your Power BI Report Server.
You can purchase SQL Enterprise Edition + Software Assurance. This give you license to install the Power BI Report Server.
Only the Content Creators (those building reports) need to have a Power BI Pro license in both cases.
Alternatively, can I use Power BI Pro Service and publish content for consumers with the understanding each consumer must also have a Power BI Pro License? The Pro license gives you the ability to share content in the Power BI Service. You don't get the Power BI Report Server in this license. You are correct, report creators and end users need Pro licenses.
In this scenario, you would have a normal SSRS report server, and the Power BI Service. They would not communicate, and you couldn't put PBI Reports on the SSRS Server.
56 Replies
I plan to upgrade from SQL Server Standard 2008 to SQL Server Standard 2016 later this year. If I want to use Power BI Report Server do I have to buy a Power BI Premium license, or can I download and run Power BI Report Server alongside or as a replacement for SSRS based on the licenses I purchase for SQL Server Standard 2016
You have two options.
You can buy Power BI Premium, this allows you to license the same number of cores that you purchase in capacity in the premium license on premises for your Power BI Report Server.
You can purchase SQL Enterprise Edition + Software Assurance. This give you license to install the Power BI Report Server.
Only the Content Creators (those building reports) need to have a Power BI Pro license in both cases.
Alternatively, can I use Power BI Pro Service and publish content for consumers with the understanding each consumer must also have a Power BI Pro License? The Pro license gives you the ability to share content in the Power BI Service. You don't get the Power BI Report Server in this license. You are correct, report creators and end users need Pro licenses.
In this scenario, you would have a normal SSRS report server, and the Power BI Service. They would not communicate, and you couldn't put PBI Reports on the SSRS Server.
Having this --> SQL Enterprise Edition + Software Assurance. This give you license to install the Power BI Report Server.
Can I install PBI Report Server on 2 machines inside my company?
2 instances of PBI Report server for diffeferent purposes
ENO- Thank you for the reply. I have something to discuss with my team.
Hi Eno,
Let me make a question about licensing?
It means that to use a PoserBI 100% on premises I need to sign an online service and pay at least U$ 4,995.00 for a P1 node? My client doesn't use cloud and will not use. He is a bank and uses just on premises solutions. I'm watching the project sinking.
Thanks a lot for your attention.
Anonymous The other option is to purchase SQL Server Enterprise Edition + Software Assurance. This would provide you the license to use the Power BI Report Server on premises only.
The online Premium sku at 5k/mo would give you the Power BI Service, and the Power BI Report Server.
If they aren't interested in online, then the only other route is SQL EE + SA
- Hi,
As a lot of people , my need are only for the power bi server on premise.
So I have understood that the best choice is to buy the SQL EE + SA.
But , even with google , it is so hard to find out a price for a simple scenario :
Just want to have a power bi server on premise on my little company.
I don't need a datacenter or something like that. Just have an ERP System ( Dynamics Navision ), a few excel file with a few data , and a HR application, and maybe some little custom developped application with sql server or access.
how do I scale the virtual server ? 1 core ? 2 cores ? X cores ? Based on the quantity of data ? Is there some feed back to advise the man who try to get new awesome tool in a little company who can't afford to pay 5000 $ /month.
I read that the minimum of core licence is 4 per virtual machine even if the machine only have two core.
That 's ok , but anyone would have a estimated or detailed licencing price for a small company with just 1 person who will create and post power bi report and 5 who would only use the report.
The on premise option is the only one acceptable , or the Bi solution won't be Power BI.
Thx for your advise.
Julien - Hi,
As a lot of people , my need are only for the power bi server on premise.
So i have understood that the best choice is to buy the SQL EE + SA.
But , even with google , it is so hard to find out a price for a simple scenario :
Just want to have a power bi server on premise on my little company.
I don't need a datacenter or something like that. Just have an ERP System ( Dynamics Navision ), a few excel file with a few data , and a HR application, and maybe some little custom developped application with sql server or access.
how do I scale the virtual server ? 1 core ? 2 cores ? X cores ? Based on the quantity of data ? Is there some feed back to advise the man who try to get new awesome tool in a little company who can't afford to pay 5000 $ /month.
I read that the minimum of core licence is 4 per virtual machine even if the machine only have two core.
That 's ok , but anyone would have a estimated or detailed licencing price for a small company with just 1 person who will create and post power bi report and 5 who would only use the report.
The on premise option is the only one acceptable , or the Bi solution won't be Power BI.
Thx for your advise.
Julien Sorry but I have an edge case kind of question here.
We are using PBI-SSRS through our SQL EE with SA license.
Under SSRS we used to role out SSRS Farms (two or three SSRS front ends with a single backend/DB server) this seems like an approach that might be even more relevant when serving up PBIX files with a ton of imported content.
How is this addressed in the license docs? I have had a very quick scan and can't seem to see find it (that may well be me being a bit thick)
many thanks
Steve
This pricing is insane. Without SA, we're looking at a minimum of $5k per month just to get licensing for an updated variation of SSRS? Yeah, I'll pass.
Power BI Report Server, although built on SSRS's on-premises server platform, is a distinct product that targets enterprise customers. Power BI Premium includes much more than Report Server -- namely, dedicated capacity in the Power BI cloud service. Similarly, Software Assurance includes many more benefits beyond Report Server; most of our enterprise customers already have it, while those who don't should definitely check out the benefits.
Alright new case for you all. :) Currently on SQL Server 2014 and SSRS 2014, running on different VMs on a fully Core + SA licensed VMware cluster. We intend to upgrade to SQL Sever 2017, and are thinking of going to Power BI Report Server's latest release. My understanding is that on the SQL and PBI Server part we are fully covered. If we *only* intend to publish Power BI reports from our small team and end users will strictly be consumers of those reports, AND we will not be using the Power BI Azure/Cloud Service, am I correct that we only need Power BI Pro licenses for our crew and we should be covered?
As I've understood your scenario, yes, you're correct.
One more licensing question for you all. Interesting question came up today. As SQL Server Enterprise w/ SA users, we're used to deploying SSRS and being fully covered to deploy paginated reports however we like. If we move to PBI Report Server this year for future growth, but ONLY continue to deploy SSRS-style paginated reports and no (even on-premises) Power BI Reports...do we actually still need to have Power BI Pro licenses? I suppose the actual question is, are Power BI Pro licenses required to deploy paginated reports to PBIRS?
No, you need Power BI Pro licenses only when you want to publish Power BI reports.
Hi,
Another new scenario...I'm putting together a data warehouse solution which will be hosted in an Azure SQL DB. I'll be using Power BI Embedded to cover most of my reporting and dashboarding requirements, using the DWH as the source. I have additional requirements for transactional reporting which I was hoping would be fulfilled by Report Builder and Power BI Report Server. These reports need to be scheduled to run periodically and sent to a file share in CSV format.
The consumers of these reports are external clients. For security I wanted to have separate instances of report server for each client.
I don't (otherwise) need Power BI Premium and I don't have SQL Server EE in the solution either. Is there a way I can licence Report Server without purchasing one of these?
If your reports are csv files I really wouldn't pay license fees for a reporting tool to be honest. Write an azure function or similar.
