Skypoint Logo - AI platform for industries
Close this search box.

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.

More Resources


Your Data, Analytics & AI Partner

Industry leaders choose Skypoint as their comprehensive and compliant Modern Data Stack Platform. A Certified Microsoft Solutions Partner, Skypoint Cloud turns siloed data into connected experiences.