Hi guys, could you help me?
I connected some collections of mongodb atlas to power bi desktop, using the connector that was released at this month.
However, when I try to schedule updates in Power BI Service, it’s returning this error:
Missing client library for datasource Visit MongoDB Atlas SQL Interface | MongoDB for more information.
I don’t know exactly what to do.
I’m running into the same error.
Prior to the release of the named connector, I set up scheduled refresh using a personal data gateway and a System DSN configured for my MongoDB database. I was hoping the named connector might remove the gateway as a dependency…
Hi Joel!
If you find any solution, could you please communicate me? 
I’m using google sheets because of this error of power bi service.
Hi Flavia!
I am running into the same error. Would you mind sharing how your google sheets work around works?
Thank you in advance.
Hi Carlos
I usually download the report of mongodb compass and import the data into google sheets, to use in power bi.
It has been necessary because I still don’t know how to solve this issue of power bi service
I see - Thanks for sharing, Flavia!
Hi everyone!
Any solution…?
Hi, I’m also trying to query Mongo (just a test db at the moment) with Power BI and also getting nowhere, same message “Missing client library for datasource”.
PowerBI (desktop at the moment) asks for a MongoDB URL, and a “database” which as an SQL guy I assume is a tablename. I use the Atlas DB connector string, name the table, and get that result.
Has anyone tried this with Tableau?
And what’s the best way of downloading and importing to google sheets? Mongo newbie here, trying to get to grips with a world where pretty much everything is in the cloud!
Hi!
I haven’t tried with Tableau…
And answering the second question, I download the reports of mongodb using mongodb compass.
In mongodb compass I can make some queries and then download this queries in a report format, just clicking in a button
Anyway, I haven’t found a solution for the main problem, did anyone have found?
Hi,
I am in the same situation and not able to setup refresh using the latest power bi connector. any solutions so far?
Hi everyone, same problem here.
I’m able to connect Power BI desktop to Atlas, but not Power BI Service. Same error message. That’s a shame because I cannot use dataflows and datamarts functionalities.
I have two questions, with the intention to find a workaround for all of us together:
Creating the report in Power BI desktop and publishing it to Power BI Service makes the dataset available in Power BI Service. However, this dataset can be used only for reports. It cannot be consumed from a dataflow or a datamart. So, it’s not a solution. Am I right?
A second approach could be using a third tool as a bridge. Some SQL database that works as a charm when connected to Atlas on one side and Power BI on the other. There should be plenty of solutions. Any recommendation? (preferably free and straightforward)
Some folks above talked about using Compass + Google Sheets this way, but it seems a little manual to me (opening a program, exporting a file, pasting the content to google sheets or whatever it takes…)
I hope we all find a solution.
Thank you!
I’ve been engaged with Microsoft support around this. We’ve had several calls to reproduce the issue, troubleshoot, and collect logging. I’ll update here if they determine a solution.
Do you have any updates from the Microsoft Team?
Hi Flavia, how are you? I’m Gabriel Nogueira, I’m starting work here at the company with Power BI and we use Mongo DB as a database. I’m having several problems (for being a beginner).
We could make a call, if you can, to understand how you’ve been importing data into Power BI.
Best
Hi All - I’m the product manager for the Atlas SQL Interface and Power BI Connector.
First up, the error “Missing client library for datasource” most probably means you may not have downloaded and installed the Atlas SQL ODBC driver. Here is the download for that driver: Download Atlas SQL ODBC Driver | MongoDB
Next, when the connection dialog asks for “database” it is referring to a database name, not a table. This is just the database to authenticate against and you will be able to build upon other databases within that cluster/Federated db, so long as you have permissions to those.
And if you want to publish and refresh this data, a Power BI Gateway is required. So if this gateway is on a server, the connector and driver must also reside on that server. You can download the connector and driver from our download center (as mentioned above).
And finally, Data flows does work with this connector+driver+on-premise gateway, here are the requirements and instructions:
Requirements:
Instructions:
let
Source = MongoDBAtlasODBC.Query(“mongodb://atlassqlsandbox-rotpc.a.query.mongodb.net/Supplies?ssl=true&authSource=admin”, “Supplies”, “select * from Sales”, null)
in
Source
I will monitor this thread, please let me know if you get stuck.
Best,
Alexi
This solution works!
Thanks.
Hi Alejandro,
I’d appreciate if you could do provide a step by step way you did it.
I’ve been trying to refresh the power bi service for mongoatlasSQL but to no avail.
Thanks in anticipation.
The steps described by @Alexi_Antonino are working fine for me also. Thank you!!
@Tunde_Morakinyo, the steps described are precise and should work also for you. Let me add some details to try to help.
Now you’re ready to fetch and use your MongoDB data from Power BI desktop.
Pay attention to your M/SQL statement. You must replace the fields inside the statement. The url is the Power BI Connector Connection String that you will find in Atlas (see screenshot provided by Alexi_Antonino). You already used that in step 2. “Supplies” is the Database Name and “Sales” is the specific collection you want to fetch. You probably need to replace the quote markers by " instead of “ and ”.
Hope it helps.
