Forum Discussion
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:
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!
I meant to the library inside R.
What library are you using: mongolite, rmongodb, rmongo....?I saw that there are differents options between each other.
Thanks!