Forum Discussion

MHaluska's avatar
MHaluska
Frequent Visitor
4 years ago
Solved

Connect MongoDB with ODBC connector problem

Hello guys!   I have an issue with an ODBC connector. I am using an ODBC DNS to connect to the MongoDB BI connector to retrieve data from a M30 type cluster. The connection is successful but its ve...
Need Help
  • MHaluska's avatar
    MHaluska
    4 years ago

    Hi v-jingzhang, thanks for your help,

     

    I have found another solution. In MongoDB there is MongoDB realm where you can make HTTP endpoints to specified collections. After you can connect to this endpoint with Power Query Web.Content function. With this connection you can also make scheduled refresh in Power BI Service as well! 🙂

     

    Best regards,

    Máté Haluska

v-jingzhang's avatar
v-jingzhang
Community Support
4 years ago

Hi MHaluska 

 

I don't find other ways except ODBC. This blog is very detailed, so hope it would be helpful: https://medium.com/qimi-techblog/connecting-mongodb-hosted-in-mongo-atlas-with-powerbi-including-m0-clusters-ae02fbef0c7d 

 

To further use it and refresh data in Power BI Service, you may need to install an on-premises data gateway and configure it to connect to the same data source for refreshing. 

 

Reference: 

https://medium.com/@luismego/yes-it-is-possible-to-connect-powerbi-cloud-version-with-mongo-9b2f3506105 

https://rukiatu.com/refreshing-odbc-datasource-from-power-bi-service/ 

 

Best Regards,
Community Support Team _ Jing

k2nneth's avatar
k2nneth
Frequent Visitor
4 years ago

Hi all, 

I still see this error and have no idea how to solve it, any advice? I tried either ANSI or Unicode but result the same.