I want to connect power query to the SharePoint folder, but I can only get to the top site level.
The function I used is EXCEL-DATA-GET DATA-GET DATA - FROM FILE-FROM SHAREPOINT FOLDER (I am using Microsoft 365 version)
Since there are thousands of files in the site, I would like to connect to a certain sub-folder.
My IT support told me he is not good at EXCEL, he can only see that it works if I connect to the site, and then filter the file name under the "File Path".
Currently I can only connect to the top level as below
https://xxxxxxx.sharepoint.com/sites/division name
But I want to connect to the sub-folder below the site level, example below
https://xxxxxxx.sharepoint.com/sites/division name/Register
https://xxxxxxx.sharepoint.com/sites/division name/Register/Reporting

