Writing to folder from R-visual in PBI Service

[Anonymous]

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 service. Hence, I’m wondering, is it possible to write from a R-file in PowerBI service to a folder on your computer, or is this feature blocked?

[v-xicai]

Hi  @Anonymous  ,

Does that make sense? If so, kindly mark the proper reply as a solution to help others having the similar issue and close the case. If not, let me know and I'll try to help you further.

Best regards

Amy

[v-xicai]

Hi @Anonymous ,

To enable scheduled refresh for the workbook containing your dataset with R scripts, you may see Configuring scheduled refresh. While first of all, you need a personal gateway installed on the machine where the file and R are located. The Power BI service accesses that workbook and re-renders any updated visuals. For more information, see Use personal gateways in Power BI.

Best Regards,

Amy 

Community Support Team _ Amy

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[ibarrau]

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,