Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
Bnemoh
Regular Visitor

MongoDB Atlas SQL

I have been trying to connect to MongoDB to query clusters, I did create an atlas connection and selected the PowerBI Connector driver for me to query the database and get data into a dataflow service on powerbi Online. I have the correct credentails but I get this error everytime I try to connect. The URL and Database are all correct, the username and password are all correct.

 

But the feedback is always Missing Client Library for datasource

Screenshot 2023-09-25 093746.png

3 REPLIES 3
Bnemoh
Regular Visitor

Hi @v-tangjie-msft 

I am actually using the cloud service to connect therefore it is not powerBI desktop I am using. Do I need to install the driver regardless? 

v-tangjie-msft
Community Support
Community Support

Hi @Bnemoh ,

 

The error message "Missing Client Library for datasource" typically indicates that the required MongoDB driver is not installed on your machine. To resolve this issue, you need to install the MongoDB ODBC driver on your machine. You can download the driver from the official MongoDB website. Once you have downloaded and installed the driver, you should be able to connect to your MongoDB database using the Power BI Connector driver. Additionally, make sure that you have the correct version of the MongoDB ODBC driver installed that is compatible with your version of Power BI. You can check the compatibility requirements on the Power BI website or in the documentation for the MongoDB ODBC driver.

 

You can refer to the following post that may be helpful to you:

How to resolve MongoDB client library missing issue? | Bold BI Support

 

Best Regards,

Neeko Tang

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

Thank you for the help. Now i have connected my powerBI to MongoDB atlas.

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Top Solution Authors
Top Kudoed Authors