cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
gnumarco Frequent Visitor
Frequent Visitor

ODBC connection is very slow with MongoDB

Hi.

I am using an ODBC DNS to connect to the MongoDB BI connector to retrieve data from a collection (my collection has 5,000,000 entries) to PowerBI.

It works, but it is veeeery slow, and this is because it goes in 2 steps:

1) It displays "Waiting for dns=MyCustomMongoDNS" and stays like this almost 10mn

2) It actually loads the data (I can see the line counter increasing), and this step is going at an acceptable speed for an ODBC connection.

 

Does anyone know what is the ODBC driver doing at step 1 ???

 

Thanks!!

 

4 REPLIES 4
Moderator v-yuezhe-msft
Moderator

Re: ODBC connection is very slow with MongoDB

@gnumarco,

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

Regards,

Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
gnumarco Frequent Visitor
Frequent Visitor

Re: ODBC connection is very slow with MongoDB

Hi @v-yuezhe-msft

I know very well how to connect to MongoDB with R, though in this particular case it is not an option, because R needs to load all the data first into a dataframe to make it available to PowerBI to load it, and DataFrames in R are poorly optimized memory-wize and my data simply do not fit in a DataFrame...

I really need a direct database connection.

Thanks for your answer!

 

Moderator v-yuezhe-msft
Moderator

Re: ODBC connection is very slow with MongoDB

@gnumarco

I would recommend  you vote up the following idea that add MongoDB connector in Power BI.

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/7017782-mongodb

Regards,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
gnumarco Frequent Visitor
Frequent Visitor

Re: ODBC connection is very slow with MongoDB

@v-yuezhe-msft

Just voted.

I hope this goes into production, MongoDB is really a great DB to be connected to!

 

Regards

 

Marc