Solved: Re: ODBC Connection Error

Anonymous · ‎02-02-2021

Hello all,

I try to connect Power BI to My Databas on MongoDB using ODBC connector.

So I added the driver and test the connection : sucess.

But when I try to connect from Power BI, I can see all the table Name but note read it, and I have this Error :

" DataSource.Error: ODBC: ERROR [HY000] [MySQL][ODBC 1.3(w) Driver][mysqld-5.7.12 mongosqld v2.14.2]Unknown database "

Any one please can help me to solve that ? Thank you.

Best,

VijayP · ‎02-02-2021

@Anonymous
Please Try this Thread which may help as solution

https://community.powerbi.com/t5/Desktop/ODBC-ERROR-HY000-MySQL-ODBC-1-2-w-Driver-mysqld-5-7-12-mong...

Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
MY Blog || My YouTube Channel || Connect with me on Linkedin || My Latest Data Story - Ageing Analysis

Proud to be a Super User!

View solution in original post

Anonymous · ‎02-02-2021

Thank you @VijayP, axactly that answer two my question. It's a small details that change all : we need to specify the name of the table when we creat the ODBC connector.

amadnani · ‎04-18-2022

How exactly does one specifity table name in the connector.? This doesn't solve the issue!

Also, the database dropdown seems to be not populating the database (even though authentication is succesful). I checked the permissions for the user and it does have required permissions to list collections and databases.