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…
One other observation… When I try and configure the connection in the Power BI service through the Settings > Manage connections and gateways link, the Save button remains disabled, even after I enter valid values in to the required fields.
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.
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!
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’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.
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.
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:
On-premise Gateway (installed and configured for the MongoDB Atlas Connector)
MongoDB ODBC Driver (downloaded and installed on same server/pc as Gateway)
Atlas Cluster (or Atlas Datasource)
Atlas Federated DB (if you created a SQL Quickstart this is fine too)
MongoDB URI for connection to your Atlas Federated DB or your SQL Quickstart Federated DB
Power BI Service
Workspace (not “My Workspace”)
Instructions:
From Power BI App, navigate to Workspaces (must have a workspace other than “My Workspace)
Select New->Dataflow
At the top of the screen, select “Add tables”
On the side navigation panel, select “Blank query”
At the bottom of the Query Window, make sure your On-Premise Data Gateway is selected from the drop down
Enter in an M and SQL statement to access your MongoDB Atlas Data
let Source = MongoDBAtlasODBC.Query(“mongodb://atlassqlsandbox-rotpc.a.query.mongodb.net/Supplies?ssl=true&authSource=admin”, “Supplies”, “select * from Sales”, null) in Source
Your table should open up in the online Power Query and now you may transform your data, save and then close it.
You can refresh this data manually or on a scheduled basis
I will monitor this thread, please let me know if you get stuck.
Best,
Alexi
Jump to Power BI Service and follow instructions provided by Alexi_Antonino.
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 ”.