MongoDB data loading into desktop

[Anonymous]

Hi,

I am getting data from MongoDB using ODBC connector, the size of the DB is in MB but loading data into the desktop takes more than hours. And any changes done in Power Query take hours to get applied. Any idea why it takes hours and what is the best solution ?

Regards,

Ashfiya

[v-jianboli-msft · Accepted solution]

Hi @Anonymous ,

Please check if you have overlooked some steps here.

Besides, you can check:

1. If data import is slow, then Extract the data from Mongo DB into a file. (as the data volume that you specified seems to be low - in thousands). Then import the file into Power BI model.
2. If the slicing and dicing is slower after data import into PowerBI, then tuning the model is required.

Best Regards,

Jianbo Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.