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 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?
3 Replies
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,
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.
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
