Hello all,
(because of powers beyond MY control, we're between vendors/partners at the moment and I'm reading/getting ambiguous info online so far, I'll post the same question on the other NAV forum and D365).
We have what I call a non-traditional configuration. Originally 2013 CRM and NAV 2014 where both on premise. We moved to D365 CRM and Business Central (v14 Spring release?) on-premise as we have custom code that is/wasn't ready for Business Central online.
Our sales guys (Enterprise Licensed) need a report built that will draw on data (like a stock level) from NAV BC. They won't be updating/writing to the NAV BC instance, just reading levels updated by the Finance team.
Do they (D-CRM-365) require licenses on the NAV BC (or other methods below?) server to access this data in the following methods that I see for building said report:
Integrated report to D-CRM-365
Custom PowerApp in the D-CRM-365 Environment
Power BI (we have Premium Per User and Pro users not integrated with NAV BC, for other offerings already and would rather not have to get sales guys licenses for 1 report)
SSRS on the On-Premise SQL server used for NAV BC (we have them licensed as SQL users here already)
Excel (we're M/O365)
Any other suggested method(s)?
Thanks all.