powre bi mongo db connect

[Gokul]

.am struck with getting data from mongo db,,,i can get the data from simba driver but i cant able to get the data from power bi connector..it showing the error as "mongo driver[odbc]:cant connect to the sql server"

[Šarka]

Hello, I would be grateful for help. Trying to conect from PBI to Mongo databaze via ODBC driver but i keep getting this error. I can upload some collections and some not. Very strange, can you advice?

Data source error ODBC Erorr (22018) My SQL ODBC 1.4a driver 5.7.12 mongosqld

[Anonymous · Accepted solution]

@Gokul,

How about you install other types of MongoDB ODBC Drivers and get data from Power BI?

You can  use DataDirect for MongoDB ODBC driver following the guide in this blog, or install MySQL driver as suggested in this similar thread.

Regards,
Lydia

[Gokul]

I used mysql for connecting mongo into power bi