Power BI Gateway authentication error

Dsmith
Member Posts: 7
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!
When we try to connect to the gateway from PowerBI using the Windows authentication, we get 'AccessUnauthorized' error.
Thanks!
0
Comments
-
follow https://powerbi.microsoft.com/en-us/documentation/powerbi-content-pack-microsoft-dynamics-nav/
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.
best regards
Franz Kalchmair, MVP
Alias: Jonathan Archer
please like / agree / verify my answer, if it was helpful for you. thx.
Blog: http://moxie4nav.wordpress.com/1 -
Thanks for your reply Jonathan.
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.0
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.7K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 116 Navision DOS
- 851 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 617 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 320 Dynamics CRM
- 111 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 990 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 35 Design Patterns (General & Best Practices)
- 1 Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1.1K General Chat
- 1.6K Website
- 83 Testing
- 1.2K Download section
- 23 How Tos section
- 252 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions