Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I get data from MongoDB with R library mongolite like this:
library(mongolite)
m <- mongo(collection = collectionname,
db = dbname,
url = urlname)
Query<-m$find(query = "{}", fields = "{\"_id\":0}", sort = "{}", skip = 0, limit = 0, handler = NULL, pagesize = 1000)
what I get in BI
I can't expand this columns like using JSON, for example.
In R Frame this columns are lists
How should I change R-script to get data from this lists too?
Hi @wicker,
You need to convert it in R. Try this formula, please.
library(mongolite) m <- mongo(collection = "inventory", db = "retail", url = "mongodb://localhost/?ssl=false") Query <- m$find(query = "{}", fields = "{\"_id\":0}", sort = "{}", skip = 0, limit = 0, handler = NULL, pagesize = 1000) nrows <- nrow(Query) colnames <- names(unlist(Query)) result <- data.frame(matrix(unlist(Query), nrow = nrows, byrow = T)) names(result) <- colnames #add names to the result set
Best Regards,
Dale
Thanks for help!
But now I get error...
Also, I have such unusual structure of lists. There are different columns in custom_fields for different documents in MongoDB. For example, there are 2 columns on screenshot below, but sometimes there are 3 or more columns or 2 another columns' names.
Hi @wicker,
Please share a sample. It would be great to have a format that can be imported into Mongo.
Best Regards,
Dale
Hi, @v-jiascu-msft
This is JSON sample from Mongo - https://pastebin.com/2QRQBJQz
Desired result from this JSON is on the screen below
All tags are in column "tags", separated by commas. For each custom_field we create column with it's value.
Hi
Were you able to get through this? I am having a similar requirement.
Thanks
Ravi
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
99 | |
76 | |
64 | |
58 |
User | Count |
---|---|
148 | |
113 | |
97 | |
84 | |
67 |