On-premises reporting with Power BI will it send data to external network

D_wathi
D_wathi used Ask the Experts™
on
Dear Experts
We are evaluating right fit product for our business processes and we found Microsoft Dynamics NAV (which is going to be business central) is right fit. We cannot keep our data in cloud and understood Dynamics NAV has on premise deployment option. Now the challenge it has become essential to have advanced analytics reporting and dashboards for which Power BI is one of the  option,  understood power BI has on premise deployment option think we have to go for Power BI Reporting server and at this moment I am not clear about licensing the advanced analytics requirement is for 15 users only.
 If we go for on premise power BI deployment, will the installed power BI application on each of the end user systems OR power BI reporting server which is behind my firewall will it send our data which is residing in on premise server to external/internet server for processing and showing up analytics/dashboards, Our requirement is code and data to be processed and rendered within the applications behind my firewall. we cannot allow our data outside our network. Please suggest.
Also if Microsoft power BI cannot work without connecting to their servers then please suggest any BI software which can suit my requirement. Thanks in advance, this is most critical decision that we have to take, please suggest.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Paul TurleyPrincipal Consultant

Commented:
The licensing requirement for Power BI Report Server is one of two options:
1. Power BI Premium capacity
2. SQL Server Enterprise with Software Assurance

If you are not using the cloud-based Power BI service, the first option probably doesn't make sense for you. If you are using the Enterprise edition of SQL Server, you can add Software Assurance to your license which allows you to legally use PBRS in addition to or in-place of SQL Server Reporting Services.

https://docs.microsoft.com/en-us/power-bi/report-server/get-started
https://www.microsoft.com/en-us/sql-server/sql-server-2017-pricing#CP_StickyNav_1

Author

Commented:
thank you very much for the reply, please help me understand if we plan to use Dynamics Navision 2016 with SQL Server standard either core based or server and Cal based in this case can we go for Power BI Premium capacity.
Principal Consultant
Commented:
Yes, you can always license Power BI Premium regardless of your SQL Server licensing, and that will allow you to use Power BI Report Server.  Quite honestly, it's not a very cost effective way to license the report server but you should compare the two options and decide.  You can always check with Microsoft Sales to see if you qualify for any discounted pricing.
https://powerbi.microsoft.com/en-us/calculator/

Premium is not priced attractively for small businesses and Microsoft wants to incent everyone to move to the cloud.  If your restriction is to keep your data on prem and you can deploy reports without data in the cloud, which would probably be far less expensive to license, you could either use SSAS installed on prem or DirectQuery with SQL Server through a gateway. This lets you keep your data in your data center but your reports would use the cloud service.  That would only cost about $10/user/month for Power BI licensing.

Author

Commented:
understood per-core licensing model are sold as 2 core packs from the following https://www.microsoft.com/en-us/sql-server/sql-server-2017-pricing#ft2 . we will require SQL enterprise for following 1) dynamics navision for 15 users 2) power BI reporting server hence do we have to go for two core licensing which is 4 core packs, servers are on VM. please suggest.
Paul TurleyPrincipal Consultant

Commented:
I'm not familiar with the hardware requirements for Dynamics NAV or the SQL Serer instance it requires. For such a small user base, four cores is probably sufficient for both SQL Server and the report server but I would recommend installing them on separate virtual servers.  The good thing about virtualization is that you can always start small, perhaps use four cores for NAV/SQL Server and and two cores for the report server, and then scale-up as needed.  You can always add cores and RAM to test the performance difference before committing to licenses.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial