Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Power BI service to run R script to output to CSV

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?

 

Need Help

1 Reply

  • darentengmfs's avatar
    darentengmfs
    Icon for Post Prodigy rankPost Prodigy
    5 years ago

    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.