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

B

BYahr

New Member
Joined
Jul 12, 2023
Messages
10
Office Version
  1. 365
Platform
  1. Windows
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.
 

Excel Facts

Test for Multiple Conditions in IF?
Use AND(test, test, test, test) or OR(test, test, test, ...) as the logical_test argument of IF.
Sort by date Sort by votes
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.
 
Upvote 0
Try to use the base folderpath. The first level
 
Upvote 0
JEC said:
The parentfolder
Click to expand...
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/,,,,/
 
Upvote 0
You can locate the folder by filtering afterwards. Try for example a “does contain” filter on the last column
 
Upvote 0
JEC said:
You can locate the folder by filtering afterwards. Try for example a “does contain” filter on the last column
Click to expand...
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.
 
Upvote 0
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.
 
Upvote 0
You must log in or register to reply here.

Similar threads

E
  • Question
Return most recent data - multiple criteria
Replies
0
Views
216
Exceloway
E
P
  • Question
Power Query Performance Issues / Crashing for Small Data
2
Replies
13
Views
2K
GraH
GraH
M
  • Question
Datasource.error SharePoint: Request failed: https://..................myexcelfile.xlsx/_api/contextinfo
Replies
2
Views
559
Martinpetersson
M
N
  • Solved
Power Query Merging Multiple Excel Named Ranges
Replies
5
Views
776
GraH
GraH
P
  • Question
Power Query: Files With No Data
Replies
2
Views
555
Pulsar3000
P

Forum statistics

Threads
1,216,500
Messages
6,131,016
Members
449,615
Latest member
Nic0la

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top