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 Ranks and Rank Icons in 2020

New Ranks and Rank Icons in 2020

Read the announcement for more information!

New Kudos Given Badges Coming

New Kudos Given Badges Coming

We're rolling out new Kudos Given badges. Find out how many Kudos you've given.

November 2019 Community Highlights

November 2019 Community Highlights

Get an overview of the events and great community content from November.

Power Platform World Tour

Power Platform World Tour

Find out where you can attend!

Top Solution Authors
Top Kudoed Authors (Last 30 Days)