Power query won't refresh due to different shared drive locations among users
I have a few power query excel files that grab files from a location on the shared server and then merge them together and update a mini report/table. It works fine for me but when other try to use it, it will not refresh. It seems to be because when we get access to a shared drive, users can assign whatever letter drive they want to it. So mine is the T: drive, while someone else might have U:. When the query goes to get the files it can't find them for other users since it's looking for the T drive, and that's not the letter they have assigned.
I've tried changing the file permissions, but they were already set to None.
I'm about to go on a prolonged medical leave and was hoping my team would still have access to updating these mini reports.
Is there a way to write a get data script that will ignore the letter at the start of a pathname?
Thank you in advance.
Posted Oct 17, 2023, 4:54 PM UTC