Forum Discussion

New Member

7 years ago

Solved

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

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?

Anonymous
Not applicable
7 years ago
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
  Not applicable
  7 years ago
  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
    Not applicable
    6 years ago
    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.
Anonymous
Not applicable
5 years ago
Getting same error. Any solution to pull List data from Cosmos DB into Power BI?
Thanks in advance!