Cosmos DB Connection Issue

[biggshaad]

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?

[nimatra]

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.

[v-yuta-msft]

Hi biggshaad ,

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

Regards,

Jimmy Tao