I am trying to subset some information imported from a json into power bi. I tried the code in RStudio and it worked, but when I imported this code in Power BI, it didn't show any results. I converted the data into a data.frame, but that didn't work. can someone please help me. the code I used is: require(curl) library(jsonlite) //Here goes the json import, which I can't give because its my organizations account jsond<-fromJSON() datos<-data.frame(jsond) yr<-data.frame(jsond$record$yr) library(plyr) filter<-jsond$record$yr==2015 d<-datos[filter,] d

If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

Import Json to Power BI

Thread starter nando88
Start date Feb 17, 2017
Tags

json power bi subset

nando88

Board Regular

Feb 17, 2017

I am trying to subset some information imported from a json into power bi.
I tried the code in RStudio and it worked, but when I imported this code in Power BI, it didn't show any results.
I converted the data into a data.frame, but that didn't work.
can someone please help me.
the code I used is:

Code:

require(curl)
library(jsonlite)
//Here goes the json import, which I can't give because its my organizations account
jsond<-fromJSON()
datos<-data.frame(jsond)
yr<-data.frame(jsond$record$yr)
library(plyr)
filter<-jsond$record$yr==2015
d<-datos[filter,]
d