MongoDB Atlas Connector <> Power BI Service

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…

1 Like

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.

1 Like

Hi Joel!

If you find any solution, could you please communicate me? :wink:

I’m using google sheets because of this error of power bi service.

1 Like

Hi Flavia!

I am running into the same error. Would you mind sharing how your google sheets work around works?

Thank you in advance.

1 Like

Hi Carlos :wink:

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

1 Like

I see - Thanks for sharing, Flavia!

1 Like

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!

1 Like

Hi! :wink:

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 :wink:

Anyway, I haven’t found a solution for the main problem, did anyone have found?

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:

  1. 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?

  2. 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.

1 Like

Hi @Joel_Zehring

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.


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:


  • 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”)


  • 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

Source = MongoDBAtlasODBC.Query(“mongodb://”, “Supplies”, “select * from Sales”, null)

  • 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.


This solution works!

1 Like

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.

  1. Install Power BI desktop.
  2. Install and configure the Atlas SQL ODBC Driver as explained here:

Now you’re ready to fetch and use your MongoDB data from Power BI desktop.

  1. Install On-premise Gateway. In my case, I used this: Install an on-premises data gateway | Microsoft Learn
  2. 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 ”.

Hope it helps.

1 Like