Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
stjimi
Frequent Visitor

Parsing JSON into new columns in a table

Hi all

There is a column in my table with JSON strings. I am trying to parse the data out so each category is in a new column. 
The data looks like this: 

CustomProfileFields

{}
{"7":["Metropolitan"],"8":["New South Wales"],"10":["Primary"],"12":["Government"],"13":"0"}
{}
{"7":["Metropolitan"],"8":["New South Wales"],"10":["Tertiary"],"12":["Government"],"13":"NA"}
{"7":["Metropolitan"],"8":["South Australia"],"10":["Foundation to Year 10"],"12":["Government"],"13":"20"}

Can anyone help Please?  

1 REPLY 1
artemus
Microsoft Employee
Microsoft Employee

You can do this using the Transform -> Parse -> JSON

artemus_0-1676504757734.png

From there you just need to expand the column.

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

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

Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.