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.