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
Icon for Community Champion rankCommunity Champion
9 years ago

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

Anonymous's avatar
Anonymous
Not applicable
9 years ago

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???