Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 ?
Solved! Go to 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
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
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
Hi @Jacky,
Try this:
require(gdata) write.table(trim(dataset), file="C:/ABCD.csv", sep = "\t", row.names = FALSE, append = TRUE) plot(dataset);
source:
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
97 | |
78 | |
63 | |
55 |
User | Count |
---|---|
143 | |
109 | |
89 | |
84 | |
66 |