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 being presented and are changed as for example in the image below:
This problem is greatly impacting the activities, how can I solve this problem?
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.
11 Replies
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?
You can upload your sample file to onedrive or google drive and provide me the link.
I would like to see that whether the exact issue can be reproduced.