Log In
Register
Home
Power Query
Power Pivot
July 11, 2016
Offline
Hi,
This is just a general "does anyone have any tips" question. I am setting up a query to pull data from files sitting in a SharePoint folder. There are around 600 files. I am going to pull data from a named table in each file. The tables have around 5k rows and 34 columns of data. There is some row filtering to be done for the final output but not much more manipulation needed.
Any suggestions on how I might streamline the querying greatly received.
Thanks
Bax
Power Query
Power Pivot
Xtreme Pivot Tables
Excel for Decision Making
Excel for Finance
Excel Analysis Toolpak
Power BI
Excel
Word
Outlook
Excel Expert
Excel Customer Service
November 8, 2013
Offline
You can try getting data from folder as suggested here: https://www.myonlinetraininghu.....ror#p20450
If there are differences in columns names, the function provided there will be able to get all columns.
Power Query
Power Pivot
July 11, 2016
Offline
Hi Catalin,
Thanks for the response but what you have posted does not seem to relate to my question in this case. Should you reply be against another post?
Thanks
Bax
Power Query
Power Pivot
Xtreme Pivot Tables
Excel for Decision Making
Excel for Finance
Excel Analysis Toolpak
Power BI
Excel
Word
Outlook
Excel Expert
Excel Customer Service
November 8, 2013
Offline
Why not?
There is no difference between get data from folder and get data from sharepoint folder, they both provide a list of files in that folder. The function I mentioned is applied to the list of files in folder...
Just do the SP folder query, apply the function when you have the data tables list.
1 Guest(s)
