Forum Discussion
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...
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.