Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

July 7 - July 17 | Round 2 of the Power BI Dataviz World Championships. Don't miss your chance! Learn more

Reply
prateekraina
Memorable Member
Memorable Member

Convert string values to record in Query Editor

‎04-23-2018 10:39 AM

Hi,

 

Can anyone help me in converting string column to record in query editor.

I am pulling from a source which has some values in JSON and some as string for same column.

 

Sample Dataset:

 

TimeStampEventTypeCapabilityTypeCapabilityValueCapabilityStatus
4/18/2018 8:30:28 PM +05:30SYSTEMBATTERY_STATUS[Record]ENABLED
4/18/2018 8:30:29 PM +05:30SYSTEMINTERNET_CONNECTIONONLINEENABLED
4/18/2018 9:47:53 PM +05:30SYSTEMBATTERY_STATUS[Record]ENABLED
4/18/2018 9:47:53 PM +05:30SYSTEMINTERNET_CONNECTIONONLINEENABLED
4/18/2018 9:47:58 PM +05:30SYSTEMDEVICE_USAGE14.86ENABLED
4/19/2018 10:48:05 AM +05:30SYSTEMBATTERY_STATUS[Record]ENABLED
4/19/2018 10:48:06 AM +05:30SYSTEMINTERNET_CONNECTIONONLINEENABLED
4/19/2018 10:48:08 AM +05:30SYSTEMDEVICE_USAGE0.5ENABLED
4/19/2018 11:13:54 AM +05:30SYSTEMBATTERY_STATUS[Record]ENABLED
4/19/2018 11:13:54 AM +05:30SYSTEMINTERNET_CONNECTIONONLINEENABLED
4/19/2018 11:27:59 AM +05:30SYSTEMBATTERY_STATUS[Record]ENABLED
4/19/2018 11:27:59 AM +05:30SYSTEMINTERNET_CONNECTIONONLINEENABLED

 

I need to convert these string values to record so that i can then expand the column properly.

Any suggestion will be appreciated.

 

@ImkeF You are an expert in Power Query M. Hoping a response from you.

 

Prateek Raina

 

Labels:
Message 1 of 3
3,366 Views
0
1 ACCEPTED SOLUTION
ImkeF
Community Champion
Community Champion

‎04-23-2018 10:43 AM

Hi @prateekraina, you're welcome.

I've wrote a blogpost about it: http://www.thebiccountant.com/2017/07/25/how-to-expand-a-column-that-cannot-be-expanded-in-power-bi-...

Imke Feldmann (The BIccountant)

If you liked my solution, please give it a thumbs up. And if I did answer your question, please mark this post as a solution. Thanks!

How to integrate M-code into your solution -- How to get your questions answered quickly -- How to provide sample data -- Check out more PBI- learning resources here -- Performance Tipps for M-queries

View solution in original post

Message 2 of 3
3,505 Views
2 REPLIES 2
ImkeF
Community Champion
Community Champion

‎04-23-2018 10:43 AM

Hi @prateekraina, you're welcome.

I've wrote a blogpost about it: http://www.thebiccountant.com/2017/07/25/how-to-expand-a-column-that-cannot-be-expanded-in-power-bi-...

Imke Feldmann (The BIccountant)

If you liked my solution, please give it a thumbs up. And if I did answer your question, please mark this post as a solution. Thanks!

How to integrate M-code into your solution -- How to get your questions answered quickly -- How to provide sample data -- Check out more PBI- learning resources here -- Performance Tipps for M-queries

Message 2 of 3
3,506 Views
prateekraina
Memorable Member
Memorable Member
In response to ImkeF

‎04-23-2018 09:59 PM

@ImkeF

Thank you once again !! 

 

Prateek Raina

Message 3 of 3
3,348 Views
0

Helpful resources

Announcements
FabCon and SQLCon Barcelona 2026

FabCon & SQLCon – Barcelona 2026

Join us in Barcelona for FabCon and SQLCon, the Fabric, Power BI, SQL, and AI community event. Save €200 with code FABCMTY200.

Fabric Community Sticker Design Challenge Barcelona Carousel

Fabric Community Sticker Challenge - Barcelona 2026

If you love stickers, then you will definitely want to check out our community sticker challenge, Barcelona edition!

July Power BI Update Carousel

Power BI Monthly Update - July 2026

Check out the July 2026 Power BI update to learn about new features.

Power BI DataViz World Championships carousel

Power BI DataViz World Championships - June 2026

A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.

View All
Top Solution Authors
View All