Forum Discussion
Helper IR 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:
Thanks,
Pragati
Helper IHi Manikumar,
Thank you for your reply. I have tried different links (including some without spaces and some which point to a local drive rather than SharePoint) and I am still getting a syntax error - so I don't think that is it unfortunately. Power BI is expecting a comma immediately after the " in file..
Thanks
Steve
Super UserHi SPaine86 ,
Try on thing. In the following file path there is folder name with SPACES:
https://site.sharepoint.com/site/AnalysisTeam/Automated Reporting/VA data.csv"
Can you try renaming your folder to something like "Automated_Reporting". This should be easy to achieve. Also your csv file name has got space in it as well. Try modifying it's name to "VA_data.csv"
I think this will resolve the issue.
Thanks,
Pragati