Microsoft Power Query will cache data related to queries in Excel and Power BI which can fill up your local disk and result in error messages or difficulty loading OData feeds.
One of the most common errors seen is “(500) Internal Server Error” - this will typically be seen when a user attempts to refresh a query after having just changed their password (previous credentials are stored/cached in the file) or attempts to refresh a query that was created by a former user who no longer has active OData credentials.
Another situation that could throw this error is if you manage multiple OData feeds and apply the first set of credentials at the “https://odata.bucsanalytics.com/” level, then try connecting a second feed with a different URL.
The drop down below (seen when connecting a new feed) will default to applying your credentials at that highest level, so any subsequent connection with the same starting URL will attempt to use those initial credentials.
Always select the lowest level that is specific to your customer code:
How to Resolve
Follow the steps below to clear out the Power Query cache from within Excel (NOTE: Clearing cache will cause data previews in Power Query to take a little longer at first.):
1. In Excel, open the Query options menu by going to Data > Get Data > Query Options:
2. Select Data Load from the side menu (under GLOBAL) and scroll down to the Data Cache Management Options. Click the Clear Cache button:
