Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

MongoDB data loading into desktop

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

Need Help
  • v-jianboli-msft's avatar
    v-jianboli-msft
    3 years ago

    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.

1 Reply

  • v-jianboli-msft's avatar
    v-jianboli-msft
    Community Support
    3 years ago

    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.