Power bi conection preblem to MongoDB

I could be missing something but after getting this error, I relooked at the download instructions and realized that I hadn’t downloaded and moved the connector into the right place.

Follow all of the instructions for both mongoDB connector and the powerbi connection, which ended up working for me to clear out this issue.

@Hudson_Lorfing1 thanks for the feedback. I am working to make our doc instructions more overt around the steps, especially for the download/install of the odbc driver. This might help others.
@Gabriel_Nogueira If you are still stuck, please feel free to schedule some time with me or email me: Calendly - Alexi Antonino
alexi.antonino@mongodb.com

Best
Alexi

Hello @Alexi_Antonino, I cannot load my MongoDB database on PowerBi even after trying all methods. I tried using the ODBC method as well but it couldn’t load. Can you please help me with the same?

I keep getting the error. Could you help me with the same?

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”

Regards,
Rohan

@Alexi_Antonino : Can you please post the solution for the benefit of everyone. I too am facing the same issue where I get

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”

Regards,
Mahesh

1 Like

Here is what fixed that error for me…

delete existing ODBC connection (file → datasource settings → delete)
make the ODBC connection again (datasource settings → new → default or custom tab → save)

Not specifying any credentials / connection string properties is what made things work for me.

1 Like

Hi All - Here is a possible way around this error (see image below):
Also, make sure you are using a MongoDB Database User/Login and not the credentials you use for Atlas. And one more thing to check is that your IP address is whitelisted.
" IP Access List

Atlas only allows client connections to the database deployment from entries in the project’s IP access list. To connect, you must add an entry to the IP access list."


Hope this helps!
Alexi

2 Likes

Hello @Alexi_Antonino ,
Following the solution you preconize, I manage to make working a Power BI Desktop connexion to MongoDB Atlas using Atlas SQL with Power BI connector installed on my local machine.
Now I would like to deploy to Power BI Service and have data refreshed automaticaly.
I understand that I could do the same kind of connexion using de Power BI Gateway on premise.
So I am wondering if I could use MongoDB Atlas Business Intelligence Connector.


That would avoid the gateway dependency.
Thanks
Vinzce

Hello @Vincent_Quillet - welcome to the community. While you may use the BI Connector, it too requires an on-premise gateway when using Power BI Service. Also, Atlas SQL will eventually replace Atlas BI Connector.

With the Atlas SQL Power BI Connector you can download the Connector and Driver and configure your on-premise gateway with this connector. Download and install the Connector and ODBC Driver here.
Here are some steps to follow for the Gateway:







Let me know if you need more guidance!

Best,
Alexi

1 Like

hello Alexi

Thanks for the explanation above. However, I followed the instructions on the official documentation pages and had no issues connecting Power BI Desktop to Atlas. But I cant seem to have the same success with Power BI service.

I am having trouble getting to connect using Power Query in the cloud. I am getting the below error message

SQLSTATE: 01000
NativeError: 444
Error message: ODBC: ERROR [01000] The driver returned invalid (or failed to return) SQL_DRIVER_ODBC_VER: 03.80 (Session ID: 8bf13af0-bffe-47ba-b745-fdbc64d2c3c3, Region: europe)

Do you think you can help me with a solution for this?
Thanks and regards

Thanks a lot Alexi.
I will keep you informed
Best
Vincent

Hey Guys, do you get the solution of that Power BI connector problem ?? If yes, kindly share it, I am facing the same issue.

Hi there, did you find a solution for this? I am at exactly the same point, with the same error message.

Thanks.

Hello @Andy_M!
This error (444) usually gets invoked because of bad user/login credentials or the network IP address has not been whitelisted within Atlas. Because you stated that it worked in Power BI Desktop (you are saying you in the same spot that Royce was?), I am wondering if you need to whitelist the server IP where you have installed the power BI Gateway.

Let me know if you need any guidance on opening up the network access within Atlas. Or if you want some tips on proving out connection. I usually guide users to try to connect to the federated database via Compass or Mongo SH. I can assist you if needed.

Best,
Alexi

Hi Alexi - that would be great. I think I may need guidance on opening the network access within Atlas, but potentially some tips on proving connection would be ideal too.

Thanks,

Hello Andy! Here is a doc to help with whitelisting the IP address: https://www.mongodb.com/docs/atlas/security/ip-access-list/#std-label-access-list

Here is also my Calendly link so you may schedule some time with me. We can do a screen share and I can get you closer to connection if needed.

And if you email me, I can email you a doc (I can’t attach docs here) that contains a ton of tips and troubleshooting for Power BI. alexi.antonino@mongodb.com

1 Like

Can this error be due to the fact that my cluster is M0 and in the docs it states a higher cluster is required?

If you are using an M0, this is supported by Atlas SQL, but not the BI Connector. The BI Connector requires M10 or greater. Please verify you are using the Atlas SQL Power BI Connector with our Atlas SQL ODBC driver. Here are the docs to assist you: https://www.mongodb.com/docs/atlas/data-federation/query/sql/powerbi/connect/

1 Like

I’m using the Atlas SQL ODBC driver, thanks.

Hi guys!

I fixed that issue in Power BI Service by creating an IP Address 0.0.0.0/0, as you can see in the image

Now my cluster can be connected by any IP Addresses…

I hope it helps you!

@Flavia_Santos_de_Almeida thanks for letting other users know of this. I also want others to know that IP Address 0.0.0.0/0 is great to test connections, but then you can isolate the IP Address (say from your computer or the computer running the BI Tool - like Power BI Desktop) and add that instead of all zeros.