Combine CSVs and Keep Their Name

(AKA “Pleased to Meet You, I Hope You Guess My CSVs Name.”)

This is based on a question that floated into my inbox this week. If you’re combining a folder full of CSVs but you want to retain the name of the CSV as a column, is such a thing possible in Power BI Get Data? Of course it is! Is it hard? Not if you’re lucky enough to have this video show you how it’s done.

We use some table functions on a nested table column to knock it out nice and easy; without a lot of the helper queries that come along for the ride when you use the “Combine CSV” feature.

Share This:

Stay up to date with the latest customer data news, expert guidance, and resources.

Iteration and Error Handling in M Query

All iteration roads in M Query eventually lead to the List.Generate function. In strengthening our data manipulation skills through Power Query, we absolutely need this looping function.

More Resources

Trusted By Over 6 Million End Users​

Industry leaders and over 6 million end users choose SkyPoint as their comprehensive and compliant Modern Data Stack Platform. A Gold Certified Microsoft Partner, SkyPoint Cloud turns siloed customer data into connected customer experiences.