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.
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.