This is because your data source is stored locally on your PC, When browsing for an excel file to get data from, it'll open up windows explorer which technically is your locally stored versions rather than the cloud, hence why you are getting a path of "C:\Users\{yourusername}" in your error message. And when your coworker is trying to refresh, it's trying to read your C drive folder for the file which of course due to security it cannot do.
You'll need to connect to Excel files in OneDrive in this method for it to work.
https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-use-onedrive-business-links
Alternatively if you store the file on a Teams/SharePoint channel. You'll need to connect via "Sharepoint Online Folder" to get to the Excel file so your co-worker can access it.
https://powerbi.tips/2016/09/loading-excel-files-from-sharepoint/
You should be able to change the current report by changing the data source location, this has a few steps but this guide covers it well. https://www.c-sharpcorner.com/article/how-to-change-data-source-of-existing-report-in-power-bi/
Please note - I am not affiliated with Microsoft, I'm just an end user like yourself.
Just a regular guy doin' Data Science.
If my post has helped you, please don't forget to thumbs up or click "Accept as solution" if it solved your problem!
