Howdy, Stranger!
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
- 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
- 309 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 993 SQL General
- 384 SQL Performance
- 34 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
- 260 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
The odata.context url is invalid when trying to connect to Excel from Business Central using ODATA
chrisdf
Member Posts: 82
The message is received when trying to connect excel to an ODATA feed. The characteristics of this issue are bizarre because all of the standard Cronus web services can be picked up with no problem. However, when creating a new Page or Query and trying to connect to Excel via ODATA, the error message complaining about the context being invalid was produced.
After a lot of investigation, the problem was solved by simply clearing the Excel cache and restarting excel (remember to restart Excel before trying again!). It seems like excel is storing something in this cache (older versions?) and causes issues.
To clear the excel cache:
1. Data Tab
2. Get Data
3. Query Options
4. Data Load
5. Scroll to bottom and clear the cache.
Presuming that the cache value should be kept at 0 during any development phase and then set back on when go live??
After a lot of investigation, the problem was solved by simply clearing the Excel cache and restarting excel (remember to restart Excel before trying again!). It seems like excel is storing something in this cache (older versions?) and causes issues.
To clear the excel cache:
1. Data Tab
2. Get Data
3. Query Options
4. Data Load
5. Scroll to bottom and clear the cache.
Presuming that the cache value should be kept at 0 during any development phase and then set back on when go live??
0