Forum Discussion
Can´t read from Azure Cosmos DB (because ObjectId?)?
Hi. I have an Azure funtion that writes data to an Azure Cosmos DB. Automatically, it creates an entry like this for any document: { "_id" : ObjectId("5ac205a4115db114402c7257"), in here, all ...
Dataura,
Is there possibility that you share a JSON sample file and post expected result?
Regards,
Lydia
This is a document in the Azure Cosmos DB:
{
"_id" : ObjectId("5ac205a2341db114402c7258"),
"client_id" : "Marc",
"userName" : "51554",
"easyName" : "Marcas",
"appliance_id" : 4,
"serviceLocationId" : 25002,
"timestamp" : 1522664868326,
"datetime" : "4/2/2018 10:27:48 AM",
"appliance_type" : "Case element",
"appliance_name" : "",
"human_interaction" : 3,
"has_reactive" : 3,
"has_multiple_power" : 3
}
The "_id" : ObjectId("5ac205a2341db114402c7258") is automatically generated by Azure.
Power BI Desktop can´t read it.