Forum Discussion
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!
In the Desktop, you can create entire queries based on R or individual steps within a query based upon R.
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:
I can't show the arrays inside of the clients column.
Someone can help me???
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 "))Hi Greg_Deckler!
Can you tell me what R package are you using?
I´m a begginer in all of this R-world.
Thanks!