Hosted Database and On Premises BI Connector for M2 database

[Richard]

 

I am having some issue connection when using  the Hosted Database and On Premises BI Connector.

The steps I’ve taken so far are to

1. Download & Install The MongoDB Connector for BI (version 2.13.3 on Windows x64)
2. Run the following commands in command prompt
1. CD C:\Program Files\MongoDB\Connector for BI\2.13\bin (to point to directory where connector was installed)
2. mongosqld –-version (to see if the connector was correctly installed)
3. mongo-uri “mongodb://cluster0-shard-00-00-ez3qa.mongodb.net:27017,cluster0-shard-00-01-ez3qa.mongodb.net:27017,cluster0-shard-00-02-ez3qa.mongodb.net:27017/?ssl=true&replicaSet=Cluster0-shard-0 &retryWrites=true&w=majority” --auth -u username -p password (to connect to data set)

 

The problem comes in at step 3c when I try to connect using the “mongo-uri” command which returns the error unable to execute command: context deadline exceeded (see attached). I’ve checked over the connection string and can’t see anything wrong.

DO you know if there is a command I have missed or something I failed to install?

I am following the instructions from this webpage which walks through each step  https://medium.com/qimi-techblog/connecting-mongodb-hosted-in-mongo-atlas-with-powerbi-including-m0-clusters-ae02fbef0c7d