Data Query Folder Path for Sharepoint Drive

[muhleebbin]

Is there a way to change the following folder path so that it works on any computer that has access to this file?

C:\Users\muhleebbin\xyz company\Accounting - Finance\0-NEW F DRIVE\Controller\Bank Statements 2021\00 - All Daily\Daily Emails

The following is the Power Query Editor location for Source:

= Folder.Files("C:\Users\muhleebbin\xyz company\Accounting - Finance\0-NEW F DRIVE\Controller\Bank Statements 2021\00 - All Daily\Daily Emails")

With it's current path, I'm the only that can refresh this query, however do want others to be able to refresh from their respective computers. We all have the sharepoint synced with our desktops but another user was not able to refresh this from their computer.

Thanks in advance for your assistance

 

[Alex Blakenburg]

Try this, videos by Wyn Hopkins

 

[muhleebbin]

Thanks Alex, that was very helpful! Initially a little confusing but navigated my butt through it.