Can Power Query be used to combine data filtered from multiple workbooks stored on SharePoint (not online app)?

[BYahr]

In learning about Power Query, I was able to extract the requested data from 1 workbook. What I've been asked for is this bit of data from all of last year's daily workbooks. These are stored on the company's SharePoint. When I attempt to pull from "From File - SharePoint Folder", I get: Details: "SharePoint: Request failed: The remote server returned an error: (400) Bad Request. (Bad Request)". I've copied the path from the folder but something isn't working.

 

[BYahr]

I'm including a shortened form of the file path below for a bit of clarification.
http://..../sites/accounts/,,,,/MIMO/Individual MIMO's Current/Balance Sheets - Transaction Logs/Transaction Logs/2023 Transaction Logs/
This SharePoint folder includes daily workbooks that are set up identically. I need some filtered data from the 3rd worksheet in each file.

 

[JEC]

Try to use the base folderpath. The first level

 

[BYahr]

Try to use the base folderpath. The first level

I'm not sure what you mean by the first level.

 

[JEC]

The parentfolder

 

[BYahr]

The parentfolder

I did get past the error but cannot locate the folder or files that are needed. I'm about 5 steps away from the folder I need.
http://..../sites/accounts/,,,,/

 

[JEC]

You can locate the folder by filtering afterwards. Try for example a “does contain” filter on the last column

 

[BYahr]

You can locate the folder by filtering afterwards. Try for example a “does contain” filter on the last column

No success yet. Tried several filtering options and it's just not getting anywhere close to where these files are stored. Like I'm seeing file names from 2016 and I need 2023. I was pretty sure this would work but not yet. I'll keep trying. Thanks.

 

[BYahr]

Perhaps this is not the right option for what I need this time. When I move to this PC's hard drive (rather than SharePoint) my return is a list of file names rather than the option to filter the data contained within the files.

 

[GraH]

Try the functions of Imke Feldmann

Improve File Import from SharePoint in Power BI and Power Query –

The default way to retrieve files from a SharePoint folder is slow and getting a single file cumbersome. See functions that improve import from Sharepoint.

www.thebiccountant.com