Parse data from an Access Database into Excel to use in a list or filter in PBI

[ExcelGuy]

Hey everyone! First time user of PowerbI but longtime Excel/Access user here. I am developing a dashboard through PBI but I need to parse data in one/multiple columns that is a string or non-delimited string. This will help my filtering a slicing in PBI but I was curious if it was easier to do the parse in PBI or Excel? Below is a screenshot of my dataset as it sits in Excel and I would like to find a PowerQuery formula solution in M or a solution in PBI as the data is live and will be published to SharePoint. Thank you!

-ExcelGuy

[Kerrymr]

Hi ExcelGuy,

I would parse it in excel. 

I like to have my data as clean as possible to limit the work powerbi has to do.

If you want to try it in Powerbi.

Click on the Edit queries button in the home tab.

Select your query and use the split column button.

Try that let me know if you have any other questions.

Kerry

[ExcelGuy]

Kerry,

What would your solution be in Excel? Create a formula in PowerQuery before the data gets to Power BI?