Forum Discussion
Power BI & MongoDB
Hi Everyone!
I´m working with MongoDB as data source of my Power BI.
I created a ODBC conector with this driver:
https://www.progress.com/odbc/mongodb?sfdcid=701a0000002MkKS&cmpid=ddblog
And I have the impression that there isn´t a estable connection or it doesn´t work fine.
It takes so much time refreshing data and sometimes show me a error.
Anyone who has worded with MongoDB and Power BI together can tell me their impressions??
Work fine together ??
Thanks!
10 Replies
- Greg_DecklerCommunity Champion
Well, anything going through ODBC is going to be slow. You might consider using R to connect to mongodb using rmongodb package:
http://stackoverflow.com/questions/35028809/connect-r-to-remote-mongodb-with-rmongodb
- AnonymousNot applicable
Hi Greg_Deckler!
Can you explain me more about this way you told me?I don't see exactly what steps I have to do and the interaction between R and Power BI.
Thanks!- Greg_DecklerCommunity Champion
In the Desktop, you can create entire queries based on R or individual steps within a query based upon R.
- v-qiuyu-msftCommunity Support
Hi Anonymous,
Based on my research, we connect to MongoDB via MongoDB ODBC Driver generally, as this driver is not published by Microsoft. It may be have some issue when integrate with Power BI Desktop. In your scenario, when you refresh the data, which error throws out?
By the way, there is already a idea about developer built-in MongoDB data source, you can also vote on it: MongoDB.
Best Regards,
Qiuyun Yu- AnonymousNot applicable
Thanks for the answers!
I'm trying differents ways to upload the model.
I will proof the R connection as you tell me, Greg_Deckler.
v-qiuyu-msft, I jus voted for the idea , I will wait for the conclusion.Regards.