How to connect to Mongo DB via ODBC or any other connector

JAM_99 — Mon, 23 Nov 2020 15:06:20 GMT

Hello Everyone,

I am trying to connect to Mongo BD (Mongo DB Atlas Replica Set) from Power BI Service & Power BI desktop but I am facing some issues. As follows:-

Mongo DB to Power BI Desktop Connection:

As per the documentation, we should be able to connect Mongo DB to Power BI Desktop using ODBC Connector after installing ODBC Mongo DB Driver & creating the System DSN. But it is not connecting using this method
I am able to connect to Power BI Desktop to Mongo DB by installing Mongo DB BI Connector but in that method, I need to run some commands in Windows CMD & keep the window active for uninterrupted connection which is not possible ( https://medium.com/qimi-techblog/connecting-mongodb-hosted-in-mongo-atlas-with-powerbi-including-m0-clusters-ae02fbef0c7d )
I need a method where I can connect to Mongo DB without this issue

Mongo DB to Power BI Service Connection:

I didn't find any method to connect to Power BI Service to Mongo DB by On-Premises data gateway & dataflow without any third-party software.

Please Suggest if anyone has connected to Mongo DB.

Thank you in Advance.

JAM_99 Tracker