There are times that ODATA requests won't work and will return an error message. 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.
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 firstname.lastname@example.org.