Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

PowerBI MongoDB BI connector - MySQL auth

Hi All! So, as stated in the title: I want to connect PowerBI to my MongoDB using the BI Connector. The BI Connector (installe don the server side) basically provides a way to connect to MongoDB as...
  • Anonymous's avatar
    Anonymous
    8 years ago

    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.

Anonymous's avatar
Anonymous
Not applicable
8 years ago

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.

Anonymous's avatar
Anonymous
Not applicable
7 years ago

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"