05-05-2017 12:52 AM
With the recent announce for Power BI Premium for Power BI On Premises Server & earlier technical preview below.
According to statement "SQL Server Enterprise Edition per-core customers with active Software Assurance (SA) will also have the rights to deploy Power BI Report Server through SA entitlement.", if the company already purchase SQL Server Enterprise Edition per-core customers with active Software Assurance (SA) , then
1. The Power BI Server could be located in company network ?
2. The Power BI Report Server is different from the MS SQL Reporting Services Server which host the SSRS reports or the Power BI reports (Under Technical Preview) ?
3. Company has the rights only keep the Power BI reports inside the Power BI Report Server but not published to cloud ?
4. Any limitation for no. of users / reports stored in the Power BI Reprt Server ?
5. There is monthly fee for Power BI Premium per Node per Month, then if the Power BI reports not publish to cloud only use the Power BI Report Server. Do company pay the subscription or only puchase the SQL Server Enterprise Edition per-core customers with active Software Assurance (SA) is enough ?
05-05-2017 01:00 AM
The Technical Preview Announce ealrier should be this one.
05-05-2017 02:02 AM
Actually what means by "With Power BI Premium the same number of virtual cores an organization provisions in the cloud can also be deployed on-premises through Power BI Report Server" ?
Any Example to clarify this statement ?
05-05-2017 02:06 AM
The comments in the announcement notice (first link in the original post) worry me as some of the Microsoft responses imply that even if you have SQL via an SA license and you use the new report server purely on premises you still need Power BI user licenses to publish reports to your own server. If this is true this would likely have a significant impact on our plans to make use of Power BI.
I posted a comment asking for clarification but unfortunately it appears to have been deleted from the page.
05-05-2017 02:28 AM
If it is the case. Think if only need to store the data reports on-premises then only purchase MS SQL Server Enterprise then use Report Rebuilder and SSRS Mobile reports would be sutstitutation to Power BI.
05-05-2017 02:29 AM
Power BI Report Server is a superset of SQL Server Reporting Services. A Power BI Report Server supports Power BI reports, *plus* all the features of an SSRS report server. So if you have a Power BI Report Server, you don’t necessarily need a separate SSRS report server.
05-15-2017 07:10 PM
I've been researching this stuff today - I can answer a few of these questions:
1. Yes, a "Power BI Report Server" could be onpremise
2. "Power BI Report Server" is a full SSRS server plus more stuff, so you could migrate things over and close down the old SSRS-only server.
3. The ability to publish is from the client. If you pay for hosting, you can publish to cloud. Buying "Power BI Report Server" doesn't give you hosting.
4. Dunno - I'm looking for this too. The generic answer will be subject to CPU/etc, but there are probably some soft limits.
5. This one is a guess: I would say if you dont publish to the cloud, you don't pay for the cloud.
On the subsumed licensing question - for on premise use, you can either
1. pay for SQL Server Enterprise Edition (with SA) (which doesn't come with any cloud hosting)
2. buy PowerBI BI Premium (which DOES come with cloud hosting, but using that is optional)
05-17-2017 08:57 AM
I'm struggling with #2:
Can we still publish pbix files / reports to SSRS server (as in the current technical preview) without having to go the expensive route of full Software Assurance / Enterprise SQL or with separately purchasing Power BI Premium?
That would be a helpful option for small companies who can't go the same route as larger operations.
We really need some kind of cost effective way to let report viewers use Power BI reports without multiplying the cost of our current MS BI stack.
05-24-2017 12:13 PM
>> pay for SQL Server Enterprise Edition (with SA) (which doesn't come with any cloud hosting)
The clarification I need is if you already own SQL server 2016 Enterprise with SA what are the implications.
This should be a no extra cost update for us with the ability to let users access the reports just like we already do
with report server.