How to parse multi-value columns (comma separated values) in Power BI

A Power BI Deep-Dive | taught by Treb Gatte, Microsoft MVP
Enroll for free
Watch Intro Video
Mick Thornton

Great when importing from an multi value application, including SharePoint lists

This is the sort of skill that needs to be in every Power BI users toolbox. So many times I've connected to a SharePoint list, an InfoPath form, or an excel file, where the creator decided to allow multiple choices for a field. Basically, multip...

Mick Thornton

This is the sort of skill that needs to be in every Power BI users toolbox. So many times I've connected to a SharePoint list, an InfoPath form, or an excel file, where the creator decided to allow multiple choices for a field. Basically, multip...

Treb Gatte, Microsoft MVP
Treb Gatte, Microsoft MVP
Managing Partner

About the Instructor

Treb Gatte is the Managing Partner at TumbleRoad.com, a Microsoft Power BI Red Carpet Partner, where he helps companies achieve project management and business intelligence success.

He’s a Microsoft MVP who’s written three books on Project and SharePoint. Treb previously worked as the Business Intelligence Program Manager on the Microsoft Project engineering team.

Questions? Contact us at info@tumbleroad.com.

If you've ever encountered data that has many values in one column, then this deep dive takes you through the steps to make this data useful in Power BI. An example is Country, where the data has Canada, Australia, Germany as a single value in the column.

This 10 minute video discusses the technique, walks you through the steps and discusses a workaround for some problematic behavior. Also included is the PBIX file to download so that you can connect it to your instance and see it in action.

Course Contents

1 Video
1 Download

Course Curriculum