Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Combining tables from files in a Sharepoint folder

Hi, Fairly new to PQ with Excel and have run into a wall and would greatly appreciate some help.   Background - Sharepoint folder holding up to 20 files with one table each with same structure, d...
Data Protection
Need Help
Tips and Tricks
christinepayton's avatar
christinepayton
Icon for Most Valuable Professional rankMost Valuable Professional
2 years ago

This is exactly what the SharePoint folder connector does. If you do get data -> SharePoint folder, give it your site URL, then filter that query on the path column to the specific folder you want, and expand, that should do it. 🙂

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    Hi, yes I have tried that one, but - as the Sharepoint structure is big, it becomes very very slow to read and update the query.