MongoDB Atlas to PowerBI: Connection very slow... 😴

[Anonymous]

Hello,

our Company want to connect our MongoDB Atlas database to PowerBI via ODBC. But the connection is very slow (10 min for an almost empty table). Other BI tools (like QlikView) have no problems and load the tables within two seconds.

Is there a solution or will we not be able to connect to Power BI?

(Used odbc: https://github.com/mongodb/mongo-odbc-driver/releases )

[v-lili6-msft]

hi  @Anonymous 

As smoupre's post in this similar thread, anything going through ODBC is going to be slow, consider using R to connect to MongoDB.

https://stackoverflow.com/questions/35028809/connect-r-to-remote-mongodb-with-rmongodb

or try to reinstall ODBC as below document:

https://docs.mongodb.com/bi-connector/master/tutorial/install-bi-connector-windows#install-bic-windows

Regards,

Lin