Troubleshooting OData connectivity issues in Excel
· One min read
When attempting to connect OData sources to Excel, you may encounter errors.
One recurring issue is described in this post, along with troubleshooting steps.
The error often encountered is:
Unable to connect
We encountered an error while trying to connect.
We are unable to resolve the type name 'Source' to an EdmType
I've found success in resolving this error by clearing the cache in Excel. Here's how you can do it:
Depending on the version of Excel you have installed, there are various methods to clear the cache.
Below, I'll describe the process for Excel (version 16).
1. With Excel open, navigate to Data > Get Data > Query Options
2. In the Query Options menu, locate Data Load > Data Cache Management Options.
3. Restart Excel after clearing the cache.