Having problems creating a connection to NAV on-premise in PowerApps and connecting to any of the NAV PowerBI content packs. Am getting authorization errors.
- Does anyone know if the NAV instance/service have to be configured with the NavUserPassword authentication in order for this to work?
- Does the data gateway have to be installed on the server box with NAV (it is NOT but SSL is all set up, I think correctly).
I have been trying this for days and our NAV is set to WIndows authentication. Outside the firewall, I can (1) use the Get Data command to connect PowerBI to the NAV data, can also (2) use the NAV Webclient in a browser and (3) can use the Windows 10 client app and successfully connect to NAV data. However, if I try to create a Connection in PowerApps or use 1 of the NAV "content packs" in PowerBI, I get authentication issues trying to connect to the on-premise NAV data. We are using NAV 2016 on-premise (hosted) and appropriate OData and SOAP ports have been opened
Just read the post: https://dynamicsuser.net/nav/b/peik/posts/setting-up-powerbi-online-with-dynamics-nav-docx?tempkey=9b8c06ed-9be3-4716-8528-ff1ab28181be#
In it the author mentions that "The DynamicsNAV90_NUP service has been configured with the NavUserPassword authentication."
Could that be due to using NavUserPassword vs Windows authentication?
*This post is locked for comments
I have the same question (0)
