Power BI service to run R script to output to CSV

[Anonymous]

Hi, wondering if i can get some help.

Basically, i have some CSV's in a network folder.

I need to read these Csvs, in Power BI, transform them, and then right them back as new files to the same network folder. 

Im pulling my hair out, as I am using R to write the csv, but how do it to write the CSV in the power BI service? I have an on premise gateway and ive added tthe connection to the network folder and that works fine... 

whats the best way to go about this?

[darentengmfs]

@Anonymous 

Currently, Power BI service cannot export data using R script.

You can use Power Query in Excel to transform them rather than doing it in Power BI. You can use Powershell with Task Scheduler to automatically refresh the file periodically.