R script "Token Comma expected"

Hi SPaine86 

The URL needs two sets of double quotes to escape it within the string it is inside i.e. ""url""

Try this

R.Execute("# 'dataset' holds the input data for this script#(lf)require(gdata)#(lf)write.table(trim(dataset), file=""https://site.sharepoint.com/site/AnalysisTeam/Automated  Reporting/VA data.csv"", sep = ",", row.names=FALSE)#(lf)plot(dataset);",[dataset=#"Removed Columns"])

regards

Phil

Hi SPaine86 

The R doco doesn't mention writing to a web location so the solution looks to be to write to a local file and then copy the file up to the web.

As you are using Sharepoint, can you just write locally and let the file sync to Sharepoint?

Alternatively check these articles that address the issue.

Solved: Exporting file to sharepoint using R script editor - Microsoft Power BI Community

Saving files to SharePoint folder from R - Stack Overflow

Saving a file to Sharepoint with R - Stack Overflow

Regards

Phil

Hi SPaine86 ,

Apologies for jumping in here. 

You can easily set-up scheduled exports from Power BI, everytime the data refreshes using a personal gateway which is very easy to set-up. Refer following blog if this helps:

https://community.powerbi.com/t5/Community-Blog/Schedule-Automated-Data-Exports-from-Power-BI-using-a-simple-R/ba-p/1606313

Thanks,

Pragati