Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to Solution.
Hi gerasimovav,
You can do this using sharepoint folder connector in power bi desktop. This blog clarify some details about how to achieve this.
Regards,
Jimmy Tao
Hi gerasimovav,
You can do this using sharepoint folder connector in power bi desktop. This blog clarify some details about how to achieve this.
Regards,
Jimmy Tao
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
97 | |
84 | |
67 | |
59 |
User | Count |
---|---|
150 | |
120 | |
99 | |
87 | |
68 |