Forum Discussion
ODBC MongoDB Power BI connection error
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.
4 Replies
- rajendraongole1
Super User
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
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
