Forum Discussion
Problem when exporting data to excel
I am exporting the data to excel of a power bi report, I am following the standard procedure however when opening it in excel many data do not respect the limitations and many special characters are ...
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.
I would like to get both .xls file data source as well as powerbi file.
This way I can test all three methods.