cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ExcelGuy Frequent Visitor
Frequent Visitor

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

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

 

Excel PowerQuery view.png

 

InkedExcel PowerQuery view_LI.jpg

 

2 REPLIES 2
Highlighted
Kerrymr Regular Visitor
Regular Visitor

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

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.

Edit queries.JPG

Select your query and use the split column button.

SplitColumn.JPG

 

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

Kerry

 

 

ExcelGuy Frequent Visitor
Frequent Visitor

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

Kerry,

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

Helpful resources

Announcements
New Topics Started Badges Coming

New Topics Started Badges Coming

We're releasing new versions of the badge that everyone's talking about. ;) Check your inbox for notifications.

MBAS 2020

Save the new date (and location)!

Our business applications community is growing—so we needed a different venue, resulting in a new date and location. See you there!

Difinity Conference

Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Top Solution Authors
Top Kudoed Authors (Last 30 Days)