Combine CSVs and Keep Their Name

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

(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:
Twitter
Facebook
LinkedIn
Essential Power BI Reports For Senior Living Operators

Essential Power BI Reports for Senior Living Operators

Well-crafted Power BI reports can help senior living operators turn disparate data into coherent and actionable insights.

ur senior living operation and reap serious efficiency gains, we’ve assembled a list of Power BI reports that consistently deliver the most value. Read on to learn more!

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.