Excel Forum

Speed up Power Query from SharePoint folder

baxbax

Member

Members

Power Query

Forum Posts: 122

Member Since:
July 11, 2016

Offline

May 15, 2021 - 12:18 am

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

Catalin Bombea

Iasi, Romania

Member

Dashboards

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

PowerPoint

Forum Posts: 1939

Member Since:
November 8, 2013

Offline

May 16, 2021 - 2:08 pm

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.

baxbax

Member

Members

Power Query

Forum Posts: 122

Member Since:
July 11, 2016

Offline

May 17, 2021 - 7:36 pm

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

Catalin Bombea

Iasi, Romania

Member

Forum Posts: 1939

Member Since:
November 8, 2013

Offline

May 18, 2021 - 4:43 am

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.