Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

MongoDB and PowerBi Connection

Good day

 

Anyone please assist with connecting to MongoDB via PowerBi? I am able to connect to the MongoDB via the compass application, but when I attempt to connect via PowerBi desktop the following error is noted:

 

 

Need Help
Tips and Tricks

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi  Anonymous ,

     

    The reason for this error may be login credentials and whitelisted IP address issues.

    You can try to clear the data source permissions in Power BI Desktop - File - Data Source settings - and re-edit.

    Make sure you have the latest version of Power BI Desktop:

    Download Power BI Desktop from Official Microsoft Download Center

     

    This is the related document, you can view this content:

    Solved: Error connecting using ODBC for MongoDB in PBI, Co... - Microsoft Fabric Community

     

    Best Regards,

    Liu Yang

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      I have been able to access the ODBC Ansi driver, but when tesing the connection it is not responding. I have double checked the IP address details, which is correct. I am completely lost at this stage and require your assistance?

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Good day Thank you for the reply and information. However, I have followed these steps prior to posting on this board. The credentials are correct as I am able to access the DB via MongoDB Compass Application. Is the PowerBi desktop versions essential because i am using the one from teh App Store?