Forum Discussion

biggshaad's avatar
biggshaad
New Member
8 years ago

Cosmos DB Connection Issue

I am using this endpoint to connect to my Cosmos DB:

https://[accountname].documents.azure.com:443/

 

instead of the phone in Azure:

https://[accountname].table.cosmosdb.azure.com:443/

(This endpoint won't connect with the primary key)

 

Now that I can get power BI connected, I am getting an error message below.

Any help on this?

 

Need Help

2 Replies

  • v-yuta-msft's avatar
    v-yuta-msft
    Community Support
    8 years ago

    Hi biggshaad ,

     

    Based on the information you have provided, please check if column [errors] has been removed in your Cosmos DB.

     

    Regards,

    Jimmy Tao

  • nimatra's avatar
    nimatra
    New Member
    7 years ago

    I think this is because of a mismatch in the driver versions between CosmosDB and PowerBI connector. I'm hitting the same issue there. I'm also hitting a more descriptive error when trying to connect through the ODBC driver

     

    [Microsoft][DocumentDB] (400) HTTP 400 Bad Request:

    {  
   "code":"BadRequest",
   "message":"Message: {\"Errors\":[\"The collection cannot be accessed with this SDK version as it was created with newer SDK version.\"]} 
ResourceType: Document, OperationType: Query\r\n, SDK: Microsoft.Azure.Documents.Common/2.0.0.0"
}

    Please check query syntax and try again.