Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Gateways for MongoDb connection

Hello, I have been using the MongoDB ODBC connector to bring data to PowerBI but have recently added powerBI Embedded into the site. ODBC does not allow for connection in the EMbedded application. The one solution I have found is to create a proxy DB in Azure Cosmos DB and then creating a gateway between MongoDB and Cosmos. Has anyone else used this strategy or could help with an alternative solution to allow live data to feed from MongoDB to PowerBI 

Tips and Tricks

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hello ,

    Yes i have used the connected with proxy with following steps using the Azure Cosmos DB MongoDB API to connect to the MongoDB instance and replicate the data to the Azure Cosmos DB collection.First installed and configured the On-premises Data Gateway to allow Power BI Embedded to connect to the Azure Cosmos DB collection.Then using desktop, connect to the Azure Cosmos DB collection using the Azure Cosmos DB connector .

     

    You can also look into alternatively using a third-party connector, such as CData's MongoDB connector for Power BI, which allows you to connect directly to MongoDB from Power BI Desktop without the need for a gateway or proxy database. This can simplify your setup and improve performance by eliminating the need for data replication.

    Let me know how was your experience with this ,Have a great day 

    Thanks !