cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper III
Helper III

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

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

 

2 REPLIES 2
Highlighted
Community Support
Community Support

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

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

 

Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the others find it more quickly.
Highlighted
Helper III
Helper III

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

Hi @v-frfei-msft 

 

Thank you so much your response

 

thanks and regards

Herwin

Helpful resources

Announcements
August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

July 2020 Community Highlights

July 2020 Community Highlights

Learn about the exciting things that happened in July.

Upcoming Events

Upcoming Events

Wondering what events you could join or have an event to promote yourself? Check out our Upcoming Events.

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

We are thrilled to announce we will begin running a monthly webinar series named Power BI Dev Camp.

Top Solution Authors
Top Kudoed Authors