Unable to Connect MongoDB Atlas with Power BI

[PremK]

In my Org, we are creating a website which uses MongoDB  to store the data. I'm trying to connect the MongoDB Atlas with Power BI to create report, but I was unable to connect, CAN ANYONE SUGGEST ME A SOLUTION PLEASE.
The error showing is_

[v-heq-msft]

Hi @PremK ,
Thanks for @AnalyticPulse  patience in responding. I looked for documentation and found an article about connecting to MongoDB Atlas. you can choose to connect to a MongoDB Atlas federated database from Power Query Online using the Atlas SQL interface or you can connect to a MongoDB Atlas federated database from Power Query Desktop using the Atlas SQL interface. Atlas federated database from Power Query Desktop using the Atlas SQL interface. For detailed configuration and prerequisites, you can check this document.
MongoDB Atlas SQL interface connector (Beta) - Power Query | Microsoft Learn

Best regards,

Albert He

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

[AnalyticPulse]

you have to install MongoDB driver for connection.
Download MongoDB ODBC Driver
you also need to set up a System DSN (data source name) or user dsn to configure the connection settings.

while connecting to mondodb form powerbi you have to choose odbc connection and then select the DSN you configured and provide the authentication details.
If this helped, Follow this blog for more insightful information about data analytics
https://analyticpulse.blogspot.com/2024/03/superstore-sales-2022-vs-2023-year-on.html
https://analyticpulse.blogspot.com/
Please Subscribe AnalyticPulse on YouTube for future updates:
https://www.youtube.com/@AnalyticPulse
Please subscribe CogniJourney On Youtube For Daily fun facts:
https://www.youtube.com/@CogniJourney

[PremK]

But the MongoDB ODBC Driver is a Payment method option.

is there any free method available ?

[AnalyticPulse]

there is free methos available. i guess you dont have Tier M10 account of atlas. you have to connect using json data format. this is the only option till date, 
ask your client to give link and credentials for json source type. and use it to setup the dsn process. its bit lengthy process but its free. 
 

[PremK]

I'm the one who took care of MongoDB in my Org. but i was not aware of these proces, I request you that can you guide me how to do this with steps please

[AnalyticPulse]

download and install mongodb ocbc driver.
open ODBC Data Source Administrator configure a DSN for your MongoDB database;

click on add and create new data source.

select mongodb from the list.(i dont have mongodb rn because i used it last year and uninstalled when my project finished)

in connection parameters:
enter your
data source name
description
user & password

then try to test connection.

you will get connection string json link in mongodb atlas portal: you should know how to create a connection link in mongodb atlas portal. 

click on connect to cluster and then follow the process, select your database that you want to use in powerbi.

while selecting the connector type use the json connection string not the powerbi.

whwile connecting to mongodb in powerbi you have to select the odbc connection type then here you can see the data source you have created you just have to select from the list.

i know these are not the perfect steps but this is how much i can remember.

If this helped, Follow this blog for more insightful information about data analytics
https://analyticpulse.blogspot.com/

Thanks