Forum Discussion
Combine Function from csv in folder
I have a structure of folders than all contain .csv files in the same format. Using folder as the data source Power Bi does a reasonable job of transforming the data. Each file has data in the f...
Hi markpendlebury,
Yes, you could click "Use Header as First Row", then you could try to add a step and use below M code in it
= Table.SelectRows(#"Changed Type", each not Text.Contains([name], "*"))If this don't work, please correct me and inform me more detailed information
Best Regards,
Zoe Zhi
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.