Forum Discussion
Writing to folder from R-visual in PBI Service
Hi, We created an R-visual (table) that we want to automatically store as a csv-file in a folder each first day of the month. This R-script seems to be working in desktop, however, not from serv...
Hi! I think you may be able to do export with R but not like that. First consider that R in Power Bi Service is limitated to only theses packages: https://docs.microsoft.com/en-us/power-bi/connect-data/service-r-packages-support
I don't think you can't create in R something to save in our PC. We can say that the code is running on a hidden VM in azure when you see the data on Service. Something that I have seen is adding some R line codes in the Power Query steps on the Query Editor (Transform Data) to export every data refresh to a folder in the PC containing the Data Gateway.
Hope that helps,
Regards,