Forum Discussion

MissMintox's avatar
MissMintox
Helper 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
v-juanli-msft's avatar
v-juanli-msft
Community Support
8 years ago

Hi MissMintox

Since you could Parse the rows in column without empty into JSON, but it returns error for the empty row, you can first parsing a json column, then handle the error by "Replace errors".

Reference how to handle error in power bi

error handling in power query

 

Best Regards

maggie