ODBC Connection Error

[Anonymous]

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,

[Anonymous]

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]

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.

[VijayP · Accepted solution]

@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-mongosqld/td-p/568285?lightbox-message-images-568285=132688iBE91D9A3538BB9F8