
Power Query
Power Pivot

July 11, 2016

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

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
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

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)
