Adjusting file path in power query so other users can refresh queries
So I have a file for work that I’ve developed and I need to configure it so that others can refresh it. We use Box for file sharing. The problem is that when others open the file up – the source filepath is always tied to my unique user id. I need to adjust the file path somehow so that it accounts for the fact that someone else is refreshing it.
Current file path syntax: C:UsersMYUSERIDBoxBox_folder_1Box_folder2box_folder_3box_folder_4
I need the syntax to be: C:UsersANYUSERIDBoxBox_folder_1Box_folder2box_folder_3box_folder_4
I assume there is something I can do in the editor to make the file path something that is more relative, for example – adjusting the USER ID, or just giving the filepath a particular name so that it isn’t looking for my specific User ID. Any thoughts?
So I have a file for work that I’ve developed and I need to configure it so that others can refresh it. We use Box for file sharing. The problem is that when others open the file up – the source filepath is always tied to my unique user id. I need to adjust the file path somehow so that it accounts for the fact that someone else is refreshing it. Current file path syntax: C:UsersMYUSERIDBoxBox_folder_1Box_folder2box_folder_3box_folder_4I need the syntax to be: C:UsersANYUSERIDBoxBox_folder_1Box_folder2box_folder_3box_folder_4 I assume there is something I can do in the editor to make the file path something that is more relative, for example – adjusting the USER ID, or just giving the filepath a particular name so that it isn’t looking for my specific User ID. Any thoughts? Read More