Data Refresh not seeing changes in source

[stvcdms]

I am running a query locally to an exce file that's in OneDrive. The Excel file has been updated, but the query still has a cached version of the data and isn't uploading. If I recreate the query the data is current. Clearing the cache has not resolved it.

Not sure where to go, other queries rely on this one, so I can't just recreate it. Any help would be much appreciated.

[GilbertQ · Accepted solution]

Hi @stvcdms

You can clear the cache in your Power BI Desktop file. 

If you are in Power BI Desktop click on File and then Options

In the first list under Data Load it will show you how much data is used. You can then click on Clear Cache