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. 

Excel

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

b3b87b7f-058f-4d02-80e4-57c8c9098de2.png

c38b1147-b08e-403d-bb36-f79d56734a13.png

Power BI

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

ebc4e001-1821-4df5-ab4d-1173467b499a.png

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

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

Comments

0 comments

Please sign in to leave a comment.