Connecting MongoDB Enterprise and PowerBI Enterprise

[Maitreya10]

My organization has a M30 db cluster. I want to connect to it through my orgs powerBI account. The issue is my org uses ssh tunneling through a Linux machine to connect to the Mongo db cluster. How can I connect to this cluster from PowerBI using my local windows machine? I tried setting up the ODBC using db credentials, getting this error:
"We encounter an error while trying to connect.
Details: "Data source error occurred.
SQLSTATE: 01000
NativeError: 444
Error message: ODBC: ERROR [01000] The driver returned invalid (or failed to return) SQL_DRIVER_ODBC_VER: 03.80".
Any help would be appreciated, thank you!

[lbendlin]

You need some other process to take care of the tunnel management. Power BI cannot do that for you.

[Maitreya10]

That means I won't be able to connect using only the odbc driver and db credentials right? Also could you elaborate more on this other process or point me towards some documentation that helps with it?

Thank you. 

[lbendlin]

That's outside the scope of this forum. Find a forum for your specific VPN.

[Maitreya10]

Sure but could you atleast let me know if I'm in the right direction? I need to create a ssh tunnel on my local machine(one with PowerBI and ODBC driver) to connect to the mongodb through the remote linux machine right?

[lbendlin]

yes

[Maitreya10]

I've setup a ssh tunnel(local port fowarding), but still not able to connect PowerBI to MongoDB, can you help me out, the source port or forwarded port is 3307. Do I need to setup system DSN or directly connect from PowerBI using MongoDB Atlas SQL(Beta) version. 

If yes, then what should be the connection string, coz when I used the one I got from MongoDB Atlas sQL connect, it didn't work.

Thank you.

[Maitreya10]

Thank you!