Json column half as records and half as text

[Anonymous]

Hi,

So i have a exported data from azure blob to power bi. The files are in json format. When i parse the json file all columns get expanded. In this expanded column i have one more column which is in json format. I cannt parse this column as json as half the values in the columns are shown as record and half as text.

If anybody knows the solution or have solved this kind of issue please let me know

Thank you

Regards,

Rushank Patil

[Anonymous · Accepted solution]

HI all,

I foudn the solution

https://community.powerbi.com/t5/Power-Query/data-export-from-azure-blob-to-power-bi-json-file-error...

[v-stephen-msft]

Hi @Anonymous ,

You could filter out the text and then expand them.

For example, below is the a column with text and record.

Untick all the text and click OK.

Expand it.

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Hi @v-stephen-msft ,

I dont get the option to filter out as seen in screenshot ( i have even clicked on load more option but nothing comes up)