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)
Hi @riccardomuti, @Seth_C_Bauer: it seems clear to me that a Pro license is required to upload reports to PBI Report Server. However, the platform does not perform any validation and any user can upload contents. Then, how can you prevent users not having a Pro license from uploading reports? I think this licesing policy cannot be applicable if there is no means for the organization to control it. Please can you advise?
Hello @Seth_C_Bauer I read the post you mentioned but didn't get clear answer.
My major concern right now is We have total 3 SQL Server Enterprise licenses. 2 of them are through MPN and 1 of them is through SA program. The SQL Server Enterprise + SA product key is being used for different department right now. But they don't use the Power BI report server available with their SA subscription.
My question is, as it is within the organization, can we use that Power BI report Server key avilable in SA subscription and install it on a server which has SQL Server Enterprise part of our MPN subscription.
Thanks in advance.
You can run Power BI Report Server on a server/VM to which you've allocated SQL Server Enterprise + Software Assurance licenses.
Say you have, for example, SQL Server Enterprise + Software Assurance licenses for 24 cores.
Hope this example helps.
Does a customer need a minimum number of cores in their SQL EE with SA to use Power BI Report Server? My understanding was that it needed to match PBI P1 capacity as a minimum, is this correct? if so, is it the 8 v-cores (P1 front end) that need to be matched, 4 cores (P1 back end), or something else?
Per the Product Terms, there's no minimum # of cores overall or per server, but there's an effective minimum of 4 cores per physical processor or per VM. That said, for a production environment, we usually recommend at least 8 cores.