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.
Power BI
In Power BI you will find the option under File > Options and settings > Options > Data Load > Data Cache Management Options > Clear Cache.
If you have any more questions please contact us at datainsights-support@tylertech.com.
Comments
Please sign in to leave a comment.