Forum Discussion
Power BI Report Server Licensing
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.
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.
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
Isn´t SQL EE + SA going to be marginally less at best compared to Premium? I´ve seen numbers of $4 - 7k per core for SQL EE + SA against Premium at $5k (and I´m assuming both are per month).
Anonymous I haven't done a direct compare, my guess is that the SQL EE +SA would be more based on a per core license. You can license SQL in many ways, I'm not well versed on all of it, but I believe you can do both subscription or yearly.
I've seen this statement everywhere "...to purchase SQL Server Enterprise Edition + Software Assurance" to license PBI Report, BUT no word on the pricing page of Power BI itself (https://powerbi.microsoft.com/en-us/pricing) regarding this. And the pricing pages for SQL (either 2016/2017) also don't mention the possibility to use this licensing (per core) to license PBI Report (instead of using Premium.
Any reason for that?