Execution result in R.Execute (export data to csv file)

[Jacky]

Hello Cummunity,

I am trying to export data to csv file in power query as part of the data loading of my model.
I am using :

Source="some table...",
RScript = R.Execute("write.csv(dataset,"C:\\ABCD.csv",[dataset=Source])
in
RScript
when inside the steps of power query, the file is created successfully.
The main issue for me is when the entire model is refreshing the exporting of the table does not work (no file is created).
another thing is that the "RScript" returns an empty table, whereas I want to make sure that the file was properly exported and to have some basic information about the number of record in the file and the time the file was created.
any ideas how I can accomlish that ?

[Anonymous]

Hi, Please mention output <- dataset after your script you will get an output as a table.

let me know if it solved your issue.

Thanks,

Parul Mishra

[vcastello · Accepted solution]

Hi @Jacky

When I want to export a dataset into R I normally use ...

write.table(dataset, file="d:/path1/path2/file.txt", sep="\t", row.names=FALSE)

You can check a couple of post by the amazing @ImkeF where she explains ...

1.- how to export data to R

http://www.thebiccountant.com/2015/12/28/how-to-export-data-from-power-bi-and-power-query/

2.- Some tips&tricks for dealing with R and Power BI

http://www.thebiccountant.com/2017/08/25/tips-and-tricks-for-r-scripts-in-the-query-editor-in-power-...


If you read this ... thanks @ImkeF

[Anonymous]

Hi @Jacky,

Try this:

require(gdata)
write.table(trim(dataset), file="C:/ABCD.csv", sep = "\t", row.names = FALSE, append = TRUE)
plot(dataset);

source:

• http://www.thebiccountant.com/2015/12/28/how-to-export-data-from-power-bi-and-power-query/