How to convert JSON from CosmosDB to table in Power BI

Question

I have IoT data in CosmosDB. I would like to have column like "deviceid" and "Temperature", but don't know how to transform it. I get now columns Name and Value.&nbsp;

v-diye-msft · Answer

Hi&nbsp;Anonymous&nbsp;
&nbsp;
Please kindly refer to the similar posts for reference:
https://community.powerbi.com/t5/Desktop/Converting-JSON-data-into-PowerBI-table/td-p/256455&nbsp;
https://community.powerbi.com/t5/Power-Query/Multi-Dimensional-Json-file-to-Table/td-p/113667&nbsp;
https://community.powerbi.com/t5/Desktop/Convert-json-List-Record-to-Table-value/td-p/635575&nbsp;
&nbsp;
&nbsp;
&nbsp;
&nbsp;

anonymous · Answer

Do I need to create custom Query statement? How to refer to CosmosDB?

Forum Discussion

How to convert JSON from CosmosDB to table in Power BI

2 Replies

Related content

CosmosDB Vs Azure AI Search

Converting a Table

Convert jotfom data to table

Convert Excel columns into rows in a PBI table

Converting to Percentage