Forum Discussion
R script as data source in Power BI Desktop
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?
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.
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?
Awesome I dint even think of it..!!
Thanks alot I really appreciateHi,
I have another query regarding the Data Update in PowerBI,
As I saved the Data in .Rda file how can I update the same table in PowerBI,
I can update the .Rda file from R but again I have to change the source in the Settings Tab for the PowerBI.