PL-300: How to Split Columns in Power BI (Power Query Step by Step)

Need to split a full name, a city and state, or an order ID into separate columns? In this PL-300 lesson, learn how to split columns in Power Query, step by step, with help from our favorite customer, Barry Biscuit. In this video: • Split column by delimiter: space, comma, and custom • Left-most delimiter vs each occurrence • Renaming columns after a split • Removing hidden spaces with Trim • The leading-zero trap: why 001 becomes 1, and how to fix it This works the same in Power BI Desktop, Power BI online, and Microsoft Fabric. Part of the PL-300 in Small Steps series. Subscribe for the next lesson: cleaning dirty numbers before changing data types. #PowerBI #PL300 #PowerQuery power query split column, power bi split column, split column by delimiter, power query trim, power bi for beginners, pl-300, power query tutorial