On-Prem vs. Cloud?

---

Hi des,

 

Happy to help, but a little caveat,  I am not a MS Licensing expert, so you need to check this with the people you buy your licenses from or Microsoft direct maybe. I'm looking at the SQL Server 2017 Licensing Datasheet ( https://www.microsoft.com/en-gb/sql-server/sql-server-2017-pricing ) as I write this.

 

My understanding is that if you Buy a SQL server 2016 / 2017 Enterprise License with Software Assurance then you are allowed to download and install the Power BI Report Server on the same server you have the SQL Sever installed. It has to be Enterprise and it has to have SA. This is what we have done, and it works fine. But this is only On-Prem, as I understand it.

 

To be able to use PBI in the cloud you need a different Cloud based subscription, if you want to have both On-Prem and Cloud I think you best option is to purchase Power BI Premium  (  https://powerbi.microsoft.com/en-us/power-bi-premium/  ) this gives you both the On_Prem Report Server and the Cloud Based service.

 

With regard to the SSRS (or paginated reports as they are referred to now !) yes we have deployed both the PBI and the SSRS reports to the same PBI Report Server. We have actually gone a stage further and managed to dynamically link SSRS reports (with parameters) to PBI reports.

 

Hope this helps, happy to answer anything else if you need more info.

 

Kind Regards

Rob

 

---