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
Super UserHi 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
Helper IThank you, this has solved that error!
If I subsitute the URL for a location on my C:\ drive (e.g. My Documents) the script now runs as expected (I have to use a double \\ in the path, e.g. C:\\user\\user\\documents\\file.csv.
But using a URL doesn't work. I get the following error:
can only open URLs for readingError in file(file, ifelse(append, "a", "w")) :
cannot open the connection
Calls: write.table -> file
Execution halted
Is there a different syntax required for exporting to a web location maybe?
- PhilipTreacy
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
- SPaine86
Our plan is for Power BI Online to generate this file every time the document refreshes - so I'm not sure if it will be able to save locally and then upload again back to SharePoint (we don't have a gateway set up). I think I'll need to investigate this further - but thank you for all your help so far!