Cosmos Table DB: Expression.Error: The field 'errors' of the record wasn't found. Details: Error

[rhizohm]

I am trying to connect to a Cosmos Table DB and get the error:

Expression.Error: The field 'errors' of the record wasn't found.
Details:
    Errors=List

There is no field "errors" in my tables so this must be some internal error poking through. Thoughts on what could be going on?

[prasadm2020]

Getting same error. Any solution to pull List data from Cosmos DB into Power BI?

Thanks in advance!

[v-yuezhe-msft · Accepted solution]

@rhizohm,

What versions of Power BI Desktop do you use? Do you directly import data from tables or write SQL statement?


Is your account  an Azure Cosmos DB SQL API or Gremlin API account?  As per this official article, the Cosmos connector is only supported for Azure Cosmos DB SQL API and Gremlin API accounts.

Regards,
Lydia

[Anonymous]

It does not work this example.

Same error,

I created CosmosDb twice. I am using SQL API. 

I would like to know if this beta works or not.

I need too decide if continue working with CosmosDB or I will change to another DB

If someone can help me, I shall apreciate

Thanks a lot

JRuiz

[Anonymous]

Did anybody get the solution for this problem?

I am using Cosmos Db account with SQL API only and it is throwing me the same exception "Column 'error' not found."

Quick response will be highly appreciated.

Thank you in advance.