Forum Discussion

MissMintox's avatar
MissMintox
Icon for Helper I rankHelper I
8 years ago

Handling empty rows/cells in JSON - Power BI Quering

Searched everywhere but couldn't find something similar to this.   I got a table as below (a glimpse of it): customDimensions is the column that pulls the data in JSON format. However, there are s...
Need Help
ImkeF's avatar
ImkeF
Icon for Community Champion rankCommunity Champion
8 years ago

You can use the error-handler and "wrap" the parsing of the JSON into: 

 

try <ParseJson> otherwise []

 

This returns an empty record for the empty fields.