Get the child objects from MongoDB using R

[Anonymous]

Hi All,

  I am facing problem while accessing the child level objects from MongoDB in PowerBI using R. Below is the data schema.

  

I am using the below R scripts to fetch the documents.

library(mongolite)
c = mongo(collection = "collection_name",db="Test")
query = c$find(query = "{}", fields = "{\"_id\":0}", sort = "{}", skip = 0, limit = 0, handler = NULL, pagesize = 1000)

I get the error like below

 

Any suggestion. 

Thanks,

Sud

[v-yulgu-msft]

Hi @Anonymous,

Please test your R script in R studio to check whether it can return correct results. Also, please expand the "Error" to get detailed error message.

Regards,

Yuliana Gu

[Anonymous]

Hi @v-yulgu-msft,

  I get the error like below.

  DataFormat.Error: We cannot convert this value from its .RData representation.

  Please let me know if I need to change anything from my source.

Thanks,

Sud

[Anonymous]

Hi @v-yulgu-msft,

I checked in R studio it returns me the exact data but the format has changed. Seems there need to change in data format.

Thanks,

Sud

[v-yulgu-msft]

Hi @Anonymous,

I am not very familiar with R script. But based on my research, it looks like there might existing problems with data convertion when getting child objects from MongoDB. Maybe above error message means that the data format cannot be converted automatically. You may need to force it to be changed in R code.

Regards,

Yuliana Gu