Error while connecting MongoDB to PowerBI using MongoDB Atlas SQL (Beta)

[Ricardo_Couto]

Good morning,

I’m trying to connect a MongoDB to PowerBI using MongoDB Atlas SQL (Beta).
For some reason it is returning an error:
Details: “Data source error occurred.
SQLSTATE: 01000
NativeError: 444
Error message: ODBC: ERROR [01000] The driver returned invalid (or failed to return) SQL_DRIVER_ODBC_VER: 03.80”

I’ve also tried creating and ODBC connection on the laptop, and use it to connect to PowerBI but it’s returning error as well:
Details: “ODBC: ERROR [01000] The driver returned invalid (or failed to return) SQL_DRIVER_ODBC_VER: 03.80”

Can you support with this topic please?
Best regards & thank you in advance
Ricardo

[Ricardo_Couto]

Currently I have this version of the Driver installed on my computer.

thank you,
Ricardo

[Alexi_Antonino]

Hello @Ricardo_Couto. This error is coming up for 1 of 2 reasons (that I have observed). 1: Issue with login credentials or 2: issue with white listed IP Address.
But the big annoyance is that if you get the error on try 1, even if you fix the problem (like if you mistype your password then on the 2nd try you type it correctly) PBI holds onto the cached error.

Try out these steps to hopefully resolve this. Also, we do have new versions of the PBI Connector and ODBC driver in our download center. But the version you are using is not causing this error. Just noting this if you wanted a more up to date version. Download Atlas SQL ODBC Driver | MongoDB

[Ricardo_Couto]

Thank you so much Alexi!
Actually should I edit the permissions here? Are you available for a quick 30min call to try to troubleshoot this together?

Best,
Ricardo

[Alexi_Antonino]

Hi yes, I am available for a quick call. Email me and I will send you a zoom link: alexi.antonino@mongodb.com

Per your question you would want to delete those permissions, just to be on the safe side. An edit might get the job done, but I usually delete.

[Ricardo_Couto]

Hi Alexi,

Thank you so much for your availability.
Can you meet in 30minutes, 6pm Portugal time? I’ve just sent you this info as an email.

Best regards & thank you,

Ricardo

[nchan (namron)]

Wow MongoDB makes free Zoom Calls with users, that’s amazing :). (assuming non paying)

[Anton_Fernando]

Hi,
I’m getting the same error and interested to know what was the outcome of this ticket.

[Alexi_Antonino]

Hello @Anton_Fernando this error is a result of an issue with the connection. These are the main things to check:

1. Do you have the proper connection string? notice the format should include “…query.mongodb.net/…”
   

   

2. Do you have database access (user credentials)? and Has you IP address been whitelisted in Atlas?
   

   

Configure IP Access List Entries - MongoDB Atlas

Hope this info helps…Best, Alexi

[Anton_Fernando]

Thanks @Alexi_Antonino for the reply. Turned out the account that I was using to connect only had access to a view. I was able to connect using a different account.

[Dan_Stern]

Hey we’re having a similar issue but a different code. We’ve tried to connect through the Web version, and we didn’t get any error but it didn’t sync. then tried to do it on the Desktop app and got this error.

I didn’t see similar cases here with the same error, would love some insight.
Thanks

[Alexi_Antonino]

Hello @Dan_Stern - a few questions, are you using the MongoDB Atlas SQL Connector with the ODBC driver? Is the ODBC driver up to date (most recent)?
Where are you getting this error? Upon connection, after you enter in your user name/password?
I don’t believe I have seen this particular error before. Feel free to email me if you want to share more information privately: Alexi.antonino@mongodb.com

[Marco_N_A1 (Marco N/A)]

Hello, I am having the same error. How did you solve it? Thanks!

[Marco_N_A1 (Marco N/A)]

Hello Alexi. I am having a similar error as Dan_Stern.

How can I fix it?

[Alexi_Antonino]

Hello @Marco_N_A1 sorry you are experiencing this. It is a bug with the ODBC driver and we plan to release a fix within a week. To work around this issue right now you can tweak your db user permissions (see below). And I will work with my team to expedite the fixed release.

Here are a few ways to bypass the error you are getting:

Instead of using a “Quickstart” federated DB, create an “Advanced” configurable Federated DB Instance (FDI). This will allow you to restrict access to this FDI in the database permissions.

If you’d like to email me to provide me your exact permissions and SQL Interface configuration, I would be more than happy to get you beyond this error.

Best,
Alexi
alexi.antonino@mongodb.com
Or instead of creating the Advanced config of the Federated DB instance, you may use the Quickstart, but you must remove the “Database User Privileges” and set the built in role to read any database. I am also testing to see if it is plausible to use a Quickstart, restrict permissions based on the underlying cluster and permit using the read any db role. I will report back to this thread today to let you know what I find, and to hopefully let you know when to expect the new ODBC driver.

[Mustafa_Mahdi]

It sounds like your MongoDB Atlas ODBC driver may be outdated or mismatched with your Power BI version. I recommend downloading the latest driver from MongoDB’s official site, then reconfiguring your DSN settings to ensure a clean connection. Clearing cached credentials can also help.

In my experience with data and investigative research, tools need to be both updated and configured correctly to deliver reliable results. That’s why at https://www.aftermathinvestigations.com/, we focus on thorough fact-finding and precise setups—whether in technology or in professional investigations.

[Alexi_Antonino]

Hi All - if you have received this “panic” error, as @Marco_N_A1 pointed out, note that we have just released a new ODBC driver to fix this behavior. You may download 1.4.6 in our MongoDB Download Center: Download Atlas SQL ODBC Driver | MongoDB