Forum Discussion
R script as data source in Power BI Desktop
Hi All
I am getting Data currently from different sources in flat files and I have to perform calculations to the data and have the transformed data stored in R dataframe,
Is there any way to directly get the R dataframe which involves around 500+ lines of code calculations into powerBI from R.
Currently I have to split the Dataframe based on category and get two data sources in PowerBI based on Dashboard requirements.
Any help regarding will be appreciated.
Thanks
OK, and this might very well be my misunderstanding of R but the way that I have worked with R dataframes in the past (limited) is that I have R code that reads some source and then I compose it into a dataframe within the R code, so something like:
N <- 100 u <- rnorm(N) x1 <- rnorm(N) x2 <- rnorm(N) y <- 1 + x1 + x2 + u mydat <- data.frame(y,x1,x2)
I guess what I was suggesting is that you put the code that creates/updates your data frame into the query as an R query or R query step. Are you saying that you have the R dataframe saved to a file as if you did something like this?
save(foo,file="data.Rda")
If that is the case, couldn't you do something like:
load("data.Rda")In the first line of your R query or R query step?
5 Replies
You can create an R Script query as well as insert an R Script step into an existing query.
Hi smoupre Thanks for the review
My issue is I have the data in my R dataframe I am trying to source it to powerBI and enable the refresh on weekly basis when I execute and update my R dataframe /code weekly.
I am unable to source the R script which only involves the split part for the dataframe,
the error I get is Datasource not found in this case the Dataframe not found,
I have set the working directory as well.
ThanksOK, and this might very well be my misunderstanding of R but the way that I have worked with R dataframes in the past (limited) is that I have R code that reads some source and then I compose it into a dataframe within the R code, so something like:
N <- 100 u <- rnorm(N) x1 <- rnorm(N) x2 <- rnorm(N) y <- 1 + x1 + x2 + u mydat <- data.frame(y,x1,x2)
I guess what I was suggesting is that you put the code that creates/updates your data frame into the query as an R query or R query step. Are you saying that you have the R dataframe saved to a file as if you did something like this?
save(foo,file="data.Rda")
If that is the case, couldn't you do something like:
load("data.Rda")In the first line of your R query or R query step?
