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 ???
As smoupre's post in this similar thread, anything going through ODBC is going to be slow, consider using R to connect to MongoDB.
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!
I would recommend you vote up the following idea that add MongoDB connector in Power BI.