MongoDB ODBC configuration for Atlas

Working with Data Connectors & Integrations
1

I am trying to connect Power BI to Mongo DB Atlas

I have installed the MongoDB ODBC driver and BI Connector but still am getting error while connecting

I tried the following blogs for instructions but they are no help

I am getting the following errors, please suggest how to resolve this

image
image669×510 73.5 KB

2

image
image940×111 21.9 KB

This is the message i am getting in the BI connector

3

Hi Manish - Based on the docs you shared, I am assuming this is Atlas BI Connector that you are using? The error seems to indicate that maybe the ODBC Driver or DSN isn’t setup properly (possibly).
Did you download the latest ODBC Driver, v1.4.3?
Then in the Windows your DSN configuration should look similar to this:

Screenshot 2023-03-22 at 8.24.19 AM
Screenshot 2023-03-22 at 8.24.19 AM682×645 148 KB

Also, did you * Download and install Visual C++ Redistributable for Visual Studio 2015?

And lastly, did you make sure that the IP address was whitelisted within Atlas?

Hope this helps!

Best,
Alexi