Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
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
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
124 | |
79 | |
49 | |
38 | |
37 |
User | Count |
---|---|
196 | |
80 | |
70 | |
51 | |
42 |