Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago

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   ...
Need Help
Greg_Deckler's avatar
Greg_Deckler
Community Champion
9 years ago

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 "))
Anonymous's avatar
Anonymous
Not applicable
9 years ago

Hi Greg_Deckler!

 

Can you tell me what R package are you using?

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

 

Thanks!

    • Anonymous's avatar
      Anonymous
      Not applicable
      9 years ago

      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!