cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
dramesh18 Frequent Visitor
Frequent Visitor

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 

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: 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?

 

 

 

 


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!


5 REPLIES 5
Super User
Super User

Re: R script as data source in Power BI Desktop

You can create an R Script query as well as insert an R Script step into an existing query.


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!


dramesh18 Frequent Visitor
Frequent Visitor

Re: R script as data source in Power BI Desktop

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 

Super User
Super User

Re: 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?

 

 

 

 


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!


dramesh18 Frequent Visitor
Frequent Visitor

Re: R script as data source in Power BI Desktop

Awesome I dint even think of it..!!
Thanks alot I really appreciate 

dramesh18 Frequent Visitor
Frequent Visitor

Re: R script as data source in Power BI Desktop

Hi,
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.