Problem when exporting data to excel

[Anonymous]

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?

[BhaveshPatel]

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.

[Anonymous]

@BhaveshPatel

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?

[BhaveshPatel]

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.

[Anonymous]

@BhaveshPatel

Do you need to extract the data in .xls or the data in its source in Power BI?

[BhaveshPatel]

I would like to get both .xls file data source as well as powerbi file. 

This way I can test all three methods.

[Anonymous]

@BhaveshPatel

thank you

https://drive.google.com/open?id=0BzCkpM-t1edGYUhmVU9ZS3ZrbFk

[BhaveshPatel]

Hi @Anonymous

Sorry to get back you late. I have tried in Excel 2016 and R Environment both to export the data.

Excel 2016 comes with the predefined currency format but Export in R is clean and without any format.

If you would like to proceed using R, You need to install R Environment on your machine. 

I think this would be the most easy technique to export the data. 

You can find the file at 

https://drive.google.com/file/d/0B26iWnIZh6PSV0gzMXBveFZNN1E/view?usp=sharing

 

[Anonymous]

@BhaveshPatel

Thanks, but how do I use R on power BI? How will I export using R? I already have R installed on my machine.

[BhaveshPatel · Accepted solution]

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.

[Anonymous]

@BhaveshPatel

Many thanks, last question, will this work in the cloud?

how can i resolver this error:

"Error Message:
R. Script Error
Error in is.data.frame (x): could not find the function "trim"
Calls: write.table -> is.data.frame
Execution stopped"

[Anonymous]

@BhaveshPatel

thank's very much,

falow the link:

https://drive.google.com/open?id=0BzCkpM-t1edGYUhmVU9ZS3ZrbFk