From Azure Cosmos Db after expanding JSON(record) data column in Power BI does not showing all data

[Parth_1]

I am importing data through (Azure Cosmos Db v1) inbuilt connection in Power BI. Some of the columns present in JSON(record) format. So I am expanding the data but somehow some of the columns are getting blank values. All the columns in Cosmos Db is not reflecting in Power BI some of the data is missing after importing in Power BI.
As shown in below Image I am expanding specifications column. 
Please help me to solve this issue. 

[Parth_1]

See the related Post

Solved: How to expand record column dynamically with Power... - Microsoft Fabric Community

[v-xinruzhu-msft]

Hi @Parth_1 

1.Please make sure the format of the JSON is right.

2.If you use the column name in JSON, please make sure the column name is right.

And you can refer to the following link.

Work with JSON - Azure Cosmos DB for NoSQL | Microsoft Learn

Best Regards!

Yolo Zhu

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