Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
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
Hi @Anonymous
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?
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.
Hi @ Anonymous,
am having few problems while connecting with MongoDB Atlas SQL if i connect through Import and Transform the JSON file in power query mode than the power bi is taking very long time to Refresh as i have used pivot , groupby how to resolve this ,
and if i connect via Direct Query it is fast but am able to FLATTEN and UNWIND the few columns like k and v array of objects , but unable to to extract Array of object specific column am getting error as 1007 column not found i tried many ways but not getting correct solution , can you please guide me which method is good and direct query am using SQL Native Query option for writting SQL Query itz working but while extracting specific columns in array of objects am getting error 1007 column not find it is stored as array and objects
Check out the July 2025 Power BI update to learn about new features.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
User | Count |
---|---|
33 | |
21 | |
20 | |
13 | |
12 |
User | Count |
---|---|
27 | |
18 | |
17 | |
17 | |
14 |