Forum Discussion
PowerBI MongoDB BI connector - MySQL auth
I have found a solution: connecting via ODBC.
Installing the MySQL ODBC driver and creating an ODBC DSN using the ANSI connector fixes the problem, as the interface lets you specify the auth plugin to be used.
Tested succesfully: I can retrieve data from MongoDB to PowerBI using the BI connector and mongosql_auth plugin.
I have searched a bit more about this. It seems to be a wider problem: a lot of softwares that can connect to a MySQL database do not offer the possibility to choose which authentication plugin to use, even though the plugin is installed in addition to the MySQL client library.
This is a problem that PowerBI has, and, except if Microsoft fixes this, I don't really see a workaround, and I really NEED this to work in my company (Microsoft, if you are listening...).
Anyway, any help is welcome ;)
I have found a solution: connecting via ODBC.
Installing the MySQL ODBC driver and creating an ODBC DSN using the ANSI connector fixes the problem, as the interface lets you specify the auth plugin to be used.
Tested succesfully: I can retrieve data from MongoDB to PowerBI using the BI connector and mongosql_auth plugin.
can u pls explain clearly...am struck with getting data from mongo db,,,i can get the data from simba driver but i cant able to get the data from power bi connector..it showing the error as "mongo driver[odbc]:cant connect to the sql server"