Forum Discussion
Refresh error when other people using the file
I recommend checking the data source settings in the file to make sure all are correct and have the appropriate permissions assigned and also clearing the Power Query cache. Those are two steps that are good to start with and see if they fix the problem.
Data Source Settings in Excel/Power Query:
The cache can be cleared from Query Options:
I recommend checking the data source settings in the file to make sure all are correct and have the appropriate permissions assigned and also clearing the Power Query cache. Those are two steps that are good to start with and see if they fix the problem.
Data Source Settings in Excel/Power Query:
The cache can be cleared from Query Options:
Thank you it worked by refreshing the cache!
the file is quite old and was running locally in the past, even though it no longer has anything to do with my local data but maybe at some point back then (this is my guess the reason clear cache solved the problem)