Pathnames in Sharepoint

[adambc]

I have two Workbooks that to date have resided in the same Windows filesystem ...

WB2 has a Power Query Query/Connection to WB1 ...

Both WBs are moving to Sharepoint and I therefore need to change the pathname for WB1 in the Query/Connection in WB2 but I'm struggling with the vagaries of how to do this in Sharepoint ie how do I get a pathname in Sharepoint? ...

Can anyone help me please?

Many thanks ...

 

[Alex Blakenburg]

Mynda Treacy had an article on that not so long ago. You will find it here:
https://www.myonlinetraininghub.com/get-data-from-onedrive-or-sharepoint-with-power-query
If you are after a specific file in Sharepoint you can also go to the file in Sharepoint > click on the 3 vertical dots > Select details from the pop up menu > scroll to the bottom and you should see Path with a copy symbol.

 

[adambc]

@Alex Blakenburg

First glance looks like it's exactly what I was looking for, thanks ...

I only "work" (I'm a volunteer) on Wednesdays, so it will be next week before I can try out the various techniques (as it happens, I will need to be able to write a file to a folder) ...

Will report back then ...

Thanks again ...

 

[Alex Blakenburg]

Thanks for the update. Let me know how you go. If you are using VBA to do the writing it may get a little trickier.