Get data from multiple sharePoint folder

[Geir Hogstad]

Hi,

I have a similar worksheets in different SharePoint folder, that I would like to combine into one. 

I manage to make a new table for every worksheet, is it possible to merge all into one table, with power query (get Data)?

Best Regards

- Geir

[#2]

@Geir Hogstad 

You may use this connector

It works the same way as From Folder connector on file system. Perhaps some adjustments will be required, but it very depends on your data.

[#3]

Thank you @Sergei Baklan From SharePoint folder is not an option in my Excel. Maybe wrong license?

I can use Internet, create a worsheet for each workbook, then merge the tables in a second step.

But it would be nice, if it was possible to get all into one table with combined queries.

Here is the result:

Best Regards

- Geir

[#4 · Accepted solution]

@Geir Hogstad 

You shall not return each of Mal, Mal (2) etc into Excel sheet. Use them as connections only. Append them to each other into new resulting query which return back to Excel.

Before appending most probably you need to clean individual tables - remove empty and unnecessary rows, add headers, etc. You may do that manually one by one, or, if all tables have the same structure, automate a bit moving all workbooks into separate Sharepoint folder, connect it using connector I mentioned before, make necessary transformation on the sample only and combine all together.

[#5]

Thank you @Sergei Baklan 

It worked perfect.

Best Regards

- Geir

[#6]

@Geir Hogstad , you are welcome