Exporting data from power query to csv in sharepoint using R

Question

I hope to get a solution here. I am completely new to R and really all i need it for is to extract data from power query and append it to an existing csv file. The only export approach that i have come across only works for exporting to the local c drive as per my example below. This approach however does not work for files in sharepoint with a URL. Can you please advise on a solution? Thanks

write.csv(dataset,"c:\\documents\\test.csv ,append=true")