How to Write Mongo Query(Intellishell) in Power BI Using R Script

[her]

Hi,

I have more than 3Million Records and mongodb connect via odbc but its performance is very slow,

then i tried connect via  R Script  its connected below query used:

library("mongolite")
m<- mongo(collection= "users", db = "admin", url = "mongodb://admin:root@127.0.0.1:27017", verbose = TRUE)
users<- m$find()

users<-m$find() its working but how to write R Script for getting Count

Thanks and Regards

Herwin

[v-frfei-msft]

Hi @her ,

To be honest, I am not an expert of R, hope the online document can help you.

https://docs.microsoft.com/en-us/power-bi/desktop-r-scripts

[her]

Hi @v-frfei-msft 

Thank you so much your response

thanks and regards

Herwin