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
You can try getting data from folder as suggested here: https://www.myonlinetraininghub.com/excel-forum/power-query-members/source-data-column-headings-have-changed-throwing-a-power-query-error#p20450
If there are differences in columns names, the function provided there will be able to get all columns.
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
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.