Forum Discussion
ODBC Connection Error
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
Please Try this Thread which may help as solution
3 Replies
Anonymous
Please Try this Thread which may help as solutionThank 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.
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.
