I'm fairly new to all of this but I have a really basic R script designed to export data from Power BI as an Excel file. Unfortunately right now I can only save it locally and would like to be able to save it to a Sharepoint location instead. I've tried entering the http but it does not work. Any advice would be appreciated!
# 'dataset' holds the input data for this script
install.packages("writexl")
library("writexl")
write_xlsx(dataset, "f:/Name/Test Folder/data_export.xlsx")