OData Troubleshooting for Microsoft Excel and Power BI

There are times that ODATA requests won't work and will return an error message "We are unable to resolve the type name ___ to an EdmType". The best first step in troubleshooting these errors is to clear the data cache of Excel or Power BI. This article will show you how to do this. 


In Excel you will find the option under Data > Get Data > Query Options > Data Load > Data Cache Management Options > Clear Cache.



Power BI

In Power BI you will find the option under File > Options and settings > Options > Data LoadData Cache Management Options > Clear Cache.


If you have any more questions please contact us at datainsights-support@tylertech.com.

Was this article helpful?
1 out of 1 found this helpful
Have more questions? Submit a request



Please sign in to leave a comment.