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.
Do you need to extract the data in .xls or the data in its source in Power BI?
I would like to get both .xls file data source as well as powerbi file.
This way I can test all three methods.