Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
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!!
@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
Regards,
Lydia
Hi @Anonymous
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!
@Anonymous,
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
@Anonymous
Just voted.
I hope this goes into production, MongoDB is really a great DB to be connected to!
Regards
Marc
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Check out the October 2025 Power BI update to learn about new features.