Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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?
You can do this using the Transform -> Parse -> JSON
From there you just need to expand the column.
Check out the July 2025 Power BI update to learn about new features.