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.
Helpful resources
Microsoft Fabric Learn Together
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Power BI Monthly Update - April 2024
Check out the April 2024 Power BI update to learn about new features.
Fabric Community Update - April 2024
Find out what's new and trending in the Fabric Community.
