How to connect to Mongo DB Enterprise?

[rsong033]

I have the connection string connecting to NoSql. But when I try to create DSN using ODBC, it failed. 

Error:

Connection Failed. 

[MongoDB][ODBC 1.4(w) Driver] Lost connection to MySQL server at 'reading initial communication packet', ststem error: 0

Please help

[v-zhangti]

Hi, @rsong033 

File DSNs aren't supported. If you'd like to use a DSN, create a 64-bit System DSN  on the gateway machine.

Please refer to the following documents to see if they are helpful to you.

Power BI gateway and Report Builder support for ODBC data sources (preview) - Power BI | Microsoft D...

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[rsong033]

I don't think it would work. 

I already used System DSN. I need to use Power BI to connect to MongoDB enterprise, and create a report. The document above doesn't support Power BI Desktop. 

[rsong033]

Anyone can help on it would be appreciated. 

[rsong033]

Tried User DSN/System DSN. And Unicod Driver/ANSI Driver. Both returns the same error. Please advise.