Forum Discussion
Problem when exporting data to excel
- 9 years ago
Select R visual and Drag all the columns require in exporting data to the Values field . This will create a data frame called Dataset.
As You can see in the screenshot, I have written R script.
write.table.........
Change the path of the file to your desktop.C;/Users.........
and Execute the script by pressing play button.
You will see the R file exported to your desktop.
Alternatively, you can use write.csv method as well which I have commented here. This will save your file in the default R directory. However, You can change the file path to save it on Desktop.
Hi Anonymous
You can also use DAX Studio or R for exporting the data to excel.
I can test the output if provided the sample file.
Could you give a practical example of how I could do this through DAX or R?
And how can I pass the data on to you?