Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
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
Just voted.
I hope this goes into production, MongoDB is really a great DB to be connected to!
Regards
Marc
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
101 | |
49 | |
19 | |
12 | |
11 |