Missing values from the Body when accessing CosmosDB from Power BI

AP Mossevig 20 Reputation points
2023-12-01T10:04:15.1966667+00:00

Hi,

I'm Power BI to access a CosmosDB. I set up the connection through the Wizard under "Integrations" on the Cosmos DB account in the portal.

When retrieving the documents in Power BI, certain parts of the JSON-documents are missing. The JSON is still valid, it's only missing some properties. This is only true for some documents, but all the problematic documents are related to a couple of partitions.

Attaching screenshots of the document in CosmosDB. Here you can see that the objects in collection_data contains 3 parameters, Name, Value, Unit.

bilde

Also attaching screenshot of the same document in PowerBI. It is not transformed in any way, just loaded. Here you can see that the objects only have 2 parameters and they're both lowercase.

bilde

I need some further pointers on how to debug this, as the connection between Cosmos DB and Synapse is sort of a black box for me. I guess that the problem could be related to differences in schemas between the working and non-working partitions, but I'm not sure how to debug further.

Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
4,670 questions
Azure Cosmos DB
Azure Cosmos DB
An Azure NoSQL database service for app development.
1,535 questions
{count} votes