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.
For example, if you have Text files that all require deleting columns 1 and 4, and require naming the headings and including the source name in a column. Can you handle this with the folder option and some M Scripting?
Solved! Go to Solution.
@sonisick Yes you can use folder option to combine files from it and then do some processing to have one table. i have personally used in many cases where i have many csv files.
Proud to be a Super User!
@sonisick Yes you can use folder option to combine files from it and then do some processing to have one table. i have personally used in many cases where i have many csv files.
Proud to be a Super User!
That makes sense. Read them in, and then process them all.
Do you have any M Script files where you process all the files you just read in?
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 |
---|---|
111 | |
95 | |
77 | |
69 | |
52 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |