Folders as datasource

Hello Colleagues.

I have this task:

There are 3 different folders: shipmentdata, orderdata. trasferdata. Each folder has many excel files with the same format. I have to combine it to one table for each folder.  The result must be 3 tables: shipmentdata, orderdata. trasferdata, which will consist of all excel files. So, if anybody add a new excel file to shipmentdatafolder new data should be added to shipmentdata table.

How can I do it?

Folders as datasource works with only the local folders. But I must work with shared folders, because a lot of people will add new files to these folders.

We have office365. I've made 3 folders in my OneDrive for Business. But I don't know how to connect to this folders from PowerBI Desktop. I've also made 3 folders in Sharepoint Site, and tried to connect using "Sharepoint Folder". But I saw all excel files in one folder instead of three.

Please help.