Do you need to setup a NAV service with theCredential Type of NavUserPassword to connect PowerBI.com to NAV using the on-premise gateway?
When we try to connect to the gateway from PowerBI using the Windows authentication, we get 'AccessUnauthorized' error.
Thanks!
0
Comments
there you find following note:
You need admin credentials (or at least permissions to sales and finance data) for your Microsoft Dynamics NAV account. Only Basic (Username and Password) authentication is currently supported.
Franz Kalchmair, MVP
Alias: Jonathan Archer
please like / agree / verify my answer, if it was helpful for you. thx.
Blog: http://moxie4nav.wordpress.com/
I was wondering more about using the Power BI Gateway and trying to get it working as Steven does in this blog post where he's able to connect using his windows login:
http://thinkaboutit.be/2015/12/connecting-the-power-bi-dynamics-nav-content-package-to-a-local-nav-2016-instance/
When we set up the gateway, PowerBI.com is able to see the gateway, but it still would get the authentication error.