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.
Im trying to convert a column with JSON-data to new columns. This is my input:
I need my output like this:
I'm trying to convert my 'assessments' column to JSON in the Power Query Editor, but not getting the right outcome:
let
Source = objects,
#"Parsed JSON" = Table.TransformColumns(Source,{{"assessments", Json.Document}}),
#"Expanded assessments" = Table.ExpandRecordColumn(#"Parsed JSON", "assessments", {"36", "43"}, {"product_id", "value"})
in
#"Expanded assessments"
Thanks in advance!
Solved! Go to Solution.
Hi @lionzandvliet ,
If you have the information has you present in the first image you just need to make some addtional steps:
Check PBIX file attach, it's not based on JSON but you only need the steps after "opening" the JSON that is what I show here.
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHi @lionzandvliet ,
If you have the information has you present in the first image you just need to make some addtional steps:
Check PBIX file attach, it's not based on JSON but you only need the steps after "opening" the JSON that is what I show here.
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsCheck out the July 2025 Power BI update to learn about new features.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
User | Count |
---|---|
72 | |
67 | |
51 | |
38 | |
26 |
User | Count |
---|---|
89 | |
52 | |
45 | |
39 | |
38 |