The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event: Join us in Stockholm, September 24-27, 2024.
Save €200 with code MSCUST on top of early bird pricing!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
Hello to evereryone, I am trying to model the data for a new dashboard and don't now how to combine some csv files from different folders.
I have a master folder with the following folders inside(each week another folder is created inside the master folder):
And inside of each of the folders I have 6 csv files. I would like to combine the corresponding files between folders.
For example, I need to combine the driver_activity csv of the current 10 folders in the master folder.
Is it possible to get this thing done with power query?
Thanks in advance.
Solved! Go to Solution.
Yes, you can do that ...
a) Get data
b) Select the master folder
c) The query gives all the list, filter for .csv files
d) Combine the files data, by clicking the content column
... continue the remaining steps
Yes, you can do that ...
a) Get data
b) Select the master folder
c) The query gives all the list, filter for .csv files
d) Combine the files data, by clicking the content column
... continue the remaining steps
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the August 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
114 | |
79 | |
78 | |
44 | |
39 |
User | Count |
---|---|
150 | |
116 | |
68 | |
64 | |
58 |