ODBC MongoDB Power BI connection error

[khizar_pbi]

Hi,

I'm connecting Mongodb using an ODBC with Power BI. I followed these steps.

1. Downloaded Mongo ODBC: https://github.com/mongodb/mongo-bi-connector-odbc-driver/releases/

2. Downloaded BI Connector: https://www.mongodb.com/try/download/atlas-kubernetes-operator

3. Configured System DSN using MongoDB ODBC 1.4.5 ANSI Driver. But when I press "test" it will freeze/ become unresponsive.

4. When I add it without testing and use it in Power BI it gives this error.

I don't know if I missed some steps or did something wrong. Any help here will be much appreciated.

Thanks in advance.

[rajendraongole1]

Hi @khizar_pbi - can you check the below resolved link:

reference link:

Connecting MongoDB to Power BI: A Comprehensive Guide 101 | Hevo (hevodata.com)

resolved Link:

Solved: MONGODB Connection with power BI Issue - Microsoft Fabric Community

Hope it helps

[khizar_pbi]

Thank you for your response, however, in both links the first step is to download an ODBC driver from https://github.com/mongodb/mongo-odbc-driver/releases/ and unfortunately there's nothing in the link, the files have been removed I think. Any other source from where we can download the required driver?

[rajendraongole1]

can you please check below link

Right links:

Releases · mongodb/mongo-bi-connector-odbc-driver (github.com)

Download Power BI Connector | MongoDB

[khizar_pbi]

Yes, I'm using the same ODBC driver from here: https://github.com/mongodb/mongo-bi-connector-odbc-driver/releases/ but it is giving an error and not establishing the connection.

Is there any other way to connect without using the ODBC method?