Forum Discussion
Solved
Execution result in R.Execute (export data to csv file)
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:\\AB...
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-bi/
If you read this ... thanks ImkeF
Hi Jacky,
Try this:
require(gdata) write.table(trim(dataset), file="C:/ABCD.csv", sep = "\t", row.names = FALSE, append = TRUE) plot(dataset);
source: