cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

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 10
Super User IV
Super User IV

Re: Power BI & MongoDB

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

 


I have book! Learn Power BI from Packt


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

Anonymous
Not applicable

Re: Power BI & MongoDB

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!

Super User IV
Super User IV

Re: Power BI & MongoDB

In the Desktop, you can create entire queries based on R or individual steps within a query based upon R. 


I have book! Learn Power BI from Packt


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

Moderator v-qiuyu-msft
Moderator

Re: Power BI & MongoDB

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

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous
Not applicable

Re: Power BI & MongoDB

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.

Anonymous
Not applicable

Re: Power BI & MongoDB

Hi @Greg_Deckler!

I have created a Query based on R script to connect with Mongo DB but the table show me an ERROR colummn.


My R-Script is like this:
library(mongolite)
m<-mongo(collection="AVE",db = "MIURA",url = "url", verbose = F)
Query<-m$find(query = "{}", fields = "{\"_id\":0}", sort = "{}", skip = 0, limit = 0, handler = NULL, pagesize = 1000)

 

And the resulting table is this:

 

Captura.PNG

 

I can't show the arrays inside of the clients column.
Someone can help me???
 

Super User IV
Super User IV

Re: Power BI & MongoDB

Not sure of your data in MongoDB, I take it that the "clients" column is some sort of list/array? You may have to convert whatever it is into something Power BI understands, like a Table or List.

 

For example, here are is some R code for processing information resulting from a Machine Learning call:

 

print("Result:")
result = h$value()
print(fromJSON(result))
 
##Return results back
inter <- do.call("rbind", finalResult$Results$output1$value$Values)
MyFinalResults <- data.frame(inter)
names(MyFinalResults) <- finalResult$Results$output1$value$ColumnNames
 
rm(list=setdiff(ls(), "MyFinalResults "))

I have book! Learn Power BI from Packt


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

Anonymous
Not applicable

Re: Power BI & MongoDB

Hi @Greg_Deckler!

 

Can you tell me what R package are you using?

I´m a begginer in all of this R-world.

 

Thanks!

Super User IV
Super User IV

Re: Power BI & MongoDB

I use Microsoft R Open:

https://mran.microsoft.com/download/

 


I have book! Learn Power BI from Packt


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

Helpful resources

Announcements
Exclusive LIVE Community Event #3 – Ask Arun Anything

Exclusive LIVE Community Event #3 – Ask Arun Anything

Join us in the third Triple A event!

Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

January 2020 Community Highlights

January 2020 Community Highlights

Make sure you didn't miss any of the things that happened in the community in January!

Difinity Conference

Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Top Solution Authors
Top Kudoed Authors