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.

Brian Grant

Brian Grant

Brian Grant is a masterful Senior Analytics Consultant by day, and a Power BI legend by night. A passion for Power BI drove him to holistically master the tool from all three perspectives: M, DAX, and the visualization layer. Brian is a constant teacher who leads Power BI training sessions, while sharing his wealth of expertise through video and blogging resources.
Share on twitter
Share on facebook
Share on linkedin
Share on email


Subscribe to CSG. We’ll supply your inbox with the latest blog posts, training videos, and upcoming events.

Ready to wrangle your data?