Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.5K Microsoft Dynamics NAV
- 18.5K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 115 Navision DOS
- 854 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 615 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 262 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 992 SQL General
- 385 SQL Performance
- 33 SQL Tips & Tricks
- 34 Design Patterns (General & Best Practices)
- Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.7K General
- 1.1K General Chat
- 1.6K Website
- 79 Testing
- 1.2K Download section
- 23 How Tos section
- 259 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
OData connection to Excel using Power Pivot
Alex_Chow
Member Posts: 5,063
Following the instruction laid out here:
http://msdn.microsoft.com/en-us/library ... 6(v=nav.71).aspx
In particular here:
However, when I tried doing this in Power Pivot, it keeps saying error 401 Unauthorized.
Here's my connection string.
Anyone point me to the right direction?
http://msdn.microsoft.com/en-us/library ... 6(v=nav.71).aspx
In particular here:
4.If your Microsoft Dynamics NAV implementation requires that you use a web service access key, you must specify the NavUserPassword credentials as described in the following steps:
a. In the Advanced dialog box, in the Security section, set the Integrated Security field to Basic.
b. In the Password field, type the web service access key.
c. In the UserID field, type the user name for the Microsoft Dynamics NAV user account. For this walkthrough, use NavTest.
d. In the Source section, in the Service Document URL field, type the URL for the OData web service that you verified in the previous procedure, for example, http://localhost:7048/DynamicsNAV71/OData/.
However, when I tried doing this in Power Pivot, it keeps saying error 401 Unauthorized.
Here's my connection string.
Service Document Url=http://dynamicsnav:7048/dynamicsnav70/OData/;Include Atom Elements=Auto;Include Data Services Content=True;Include Expanded Entities=False;Namespaces to Include=*;Integrated Security=Basic;User ID=NAVUSER;Password=********;Time Out=600;Persist Security Info=False;Schema Sample Size=25;Retry Count=5;Retry Sleep=100
Anyone point me to the right direction?
Confessions of a Dynamics NAV Consultant = my blog
AP Commerce, Inc. = where I work
Getting Started with Dynamics NAV 2013 Application Development = my book
Implementing Microsoft Dynamics NAV - 3rd Edition = my 2nd book
AP Commerce, Inc. = where I work
Getting Started with Dynamics NAV 2013 Application Development = my book
Implementing Microsoft Dynamics NAV - 3rd Edition = my 2nd book
0
Comments
AP Commerce, Inc. = where I work
Getting Started with Dynamics NAV 2013 Application Development = my book
Implementing Microsoft Dynamics NAV - 3rd Edition = my 2nd book
This can be a great alternative to the RDLC reporting.
AP Commerce, Inc. = where I work
Getting Started with Dynamics NAV 2013 Application Development = my book
Implementing Microsoft Dynamics NAV - 3rd Edition = my 2nd book
I´m working on a BI system for Dynamics NAV 2013 and I would like to use this kind of connection better than SQL ODBC.
The connection (excel + powerpivot) works fine on localhost (a virtual machine on Windows Azure) with this connection string:
http://localhost:7048/dynamicsnav71/Odata
If I try to connect over Internet with Explorer or Chrome works fine too. with this string connection:
http://***.cloudapp.net:7048/dynamicsnav71/Odata
If I try to connect over Internet with Visual Studio 2012 works fine too.
with this string connection:
But it doesn't work over internet with this excel and powerpivot
http://***.cloudapp.net:7048/dynamicsnav71/Odata
Does Somebody find a solution for that?
The only change I made was to use the login account. I had to use the login and password for the account that was used for Dynamics NAV service.
AP Commerce, Inc. = where I work
Getting Started with Dynamics NAV 2013 Application Development = my book
Implementing Microsoft Dynamics NAV - 3rd Edition = my 2nd book
I use NAV 2013 R2 build 36897 and use credential type NavUserPassword to create a OData web service. When I run link "https://win2k12.nav.com:4/TestCronusDB/OData/Company('CRONUS International Ltd.')/LocationList" in browser, everything is fine. I have used my domain account and its web service access key for User ID and Password in Excel. But, when I try to test connection, I got error like below. The connection string is like below. Please help. Thank you.
Johanna
Try using IP address instead of server name.