Forum Discussion
Need help with automating the R code execution in power BI
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
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