Azure CosmosDB v2 Connector: data is showing error or no columns

[olimilo]

I'm trying to load data from our Azure CosmosDB container but whenever I try to view a table column or try to expand it, it results in an error or is not loading any columns or doesn't load at all:

Which is odd considering there should be data in there in this format:

[
    {
        "WebTrfId": "99999998_1_1_061838",
        "Fields": [
            {
                "FieldId": 7944,
                "FieldValue": "04/23/2024",
                "FieldDeleteValue": null,
                "ParentFieldReference": null,
                "ParentFieldName": null,
                "FieldName": "<p>Review_Date</p>7944",
                "VersionID": 10
            }
        ]
    }
]

Is there any way I can diagnose this or find the cause of the problem? I am able to pull the data using SQL but we were advised to use the Azure Cosmos DB v2 connector due to recent changes in the company.

[v-heq-msft · Accepted solution]

Hi @olimilo,
Based on your description, the error you mentioned is caused by not having the correct columns in the data source or the column names do not match the column names in the data source. So first, make sure that your data source (Azure Cosmos DB container) does contain the required data. You can use SQL queries or other methods to verify that the data exists. Second, check that your code is correctly fetching the data from Azure Cosmos DB. In particular, make sure that the column names and field names you are using match the actual names in the database.
You can refer to this document for more information about Azure Cosmos DB v2.
Power Query Azure Cosmos DB v2 (Beta) - Power Query | Microsoft Learn

Best regards,

Albert He

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly