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.
