Forum Discussion

sittell's avatar
sittell
New Member
2 years ago

Cosmos DB V2 Connector doesn't load json arrays

Hi,    I'm trying to build Power BI reports on top of Cosmos DB using Cosmos DB V2 Connector and a Direct Query Mode. Currently I have an issue with json data which contains arrays. In this case wh...
Need Help
AMaksymyshyn's avatar
AMaksymyshyn
New Member
2 years ago

Hi, have the same issue with Cosmos DB V2 Connector,
Example document:

{
    "id": "test",
    "metrics": [
       3, 5, 6
    ]
}

 

 

Expression.Error: The column 'id' of the table wasn't found.
Details:
id

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    Hi AMaksymyshyn, I am in the same situtation and was wondering if you have any leads in regards to the same query you mentioned above.