Forum Discussion
From Azure Cosmos Db after expanding JSON(record) data column in Power BI does not showing all data
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.
2 Replies
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.
