Forum Discussion
Question about how a Source is identified in Power Query
Click on the 'Combine Files' iconYeah, don't do that. That feature is for beginners. What you can do is study how it works, then delete that group and create your own process.
1. Connect to folder
2. Filter for the files you want
3. pick one file (any file) and transform it into the raw table
4. Inspect the M code and convert it into a function
5. Delete the steps from 3.
6. Add a custom column that calls the function you created in 4.
7. Expand the table column
8. Apply the rest of the transforms (like changing column types)
Click on the 'Combine Files' iconYeah, don't do that. That feature is for beginners. What you can do is study how it works, then delete that group and create your own process.
1. Connect to folder
2. Filter for the files you want
3. pick one file (any file) and transform it into the raw table
4. Inspect the M code and convert it into a function
5. Delete the steps from 3.
6. Add a custom column that calls the function you created in 4.
7. Expand the table column
8. Apply the rest of the transforms (like changing column types)
lbendlin-
Thank you! I'm not sure I've graduated past beginner status but you've definitely given me some new avenues to chase. (New-ish to DAX but not coding so I'll dive in)
