Forum Discussion
Need help with automating the R code execution in power BI
Hi everyone,
I wrote an R function which can take values from excel file and create a plot in R. I integrated the R code in the power BI and got the 'R' plot in power BI. I want to know whether is it possible to extract the data and create a power BI native visual instead of R visual
Also, I want to know whether is it possible to automate the entire process i.e when I open power BI, I should get the plot?
Any help is appreciated.
ive not done it, but i would assume yes that if you apply the script in power bi, if you run a refresh it should load everyting from the data output from 2 to the visuals
3 Replies
in power query you can change the context to an rscript rather than using a power query script.
in terms of automation, if you run this in the cloud service with a schedule i guess that is how you can automate. If you doing it in teh desktop it would be via a manual refresh. Is that what you asking?
Thanks for the help. Now I can data and plot as power BI visual.
Abou the automation, I want this way.
I will upload the data in either in CSV or XLS format from the local system. I want it to do the computation in R and give the output as power BI visual.
Currently, I am uploading data and dragging the columns into values field. After that, I am running the R code manually. I want to know whether I can automate the entire process with a single click (of uploading the data).
ive not done it, but i would assume yes that if you apply the script in power bi, if you run a refresh it should load everyting from the data output from 2 to the visuals
