The odata.context url is invalid when trying to connect to Excel from Business Central using ODATA

chrisdf
chrisdf Member Posts: 82
in NAV Three Tier
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??

Categories