How to bring data from Mongo DB into Microsoft Fabric

[JLYT]

Hi,

I am new to the data analysis world and my company is exploring MS Fabric as the solution.

All of our data is currently stored in Mongo Atlas and I have been using ODBC driver to connect Mongo to Power BI to create reporting dashboards. The direct connection is creating a few porblems as you can imagine there is a lot of cleaning to do in Power Query to transform the unstructured data to be used in Power BI and is not efficient.

My question is how do I feed the Mongo data into MS Fabric? At the moment, it is mainly around SQL database?

Should I connect Mongo to Azure Data Lake Gen2?

Any advise is apprentiated!

Thanks

Jennifer

[HimanshuS-msft]

Hello @JLYT 

Thanks for using the Fabric community .

I amassuming that the Mongo DB is not on Azure and if thats correct , I will highly suggest you write the data to ADLS Gen2 ( as you rightly said ) and then you use Fabric to clean and use the data . 

Thanks
HImanshu