Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

powre bi mongo db connect

.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"

Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    Anonymous,

    How about you install other types of MongoDB ODBC Drivers and get data from Power BI?

    You can  use DataDirect for MongoDB ODBC driver following the guide in this blog, or install MySQL driver as suggested in this similar thread.

    Regards,
    Lydia

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Anonymous,

    How about you install other types of MongoDB ODBC Drivers and get data from Power BI?

    You can  use DataDirect for MongoDB ODBC driver following the guide in this blog, or install MySQL driver as suggested in this similar thread.

    Regards,
    Lydia

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      I used mysql for connecting mongo into power bi

       

  • Šarka's avatar
    Šarka
    New Member
    1 year ago

    Hello, I would be grateful for help. Trying to conect from PBI to Mongo databaze via ODBC driver but i keep getting this error. I can upload some collections and some not. Very strange, can you advice?

    Data source error ODBC Erorr (22018) My SQL ODBC 1.4a driver 5.7.12 mongosqld