Problem with R script query when data contains odd number of chinese characters

[Qianwei]

I have reproduce the problem. The sample input is as follows:

then I apply a simple R script process stage to my data, the content is as follows:

output <- dataset

the script just load data from Power BI and then push data back to Power BI, the output should be the same as input,

but actually, something went wrong as you see in the following result:

you can see when a cell contains odd number of chinese characters( as the first and third line), after processed by R script,

the content in the right cell will be combined with itself splitted by a comma, and all cells on the right after that will move one cell left.

My Power BI version is 2.57.5068.501 64-bit.

[v-qiuyu-msft]

Hi @Qianwei,

Based on my test in Power BI desktop version 2.57.5068.721 64-bit (April 2018), the same R script out a table with the same data as before using R script. I would suggest you update the Power BI desktop to the latest version then test again. 

Best Regards,
Qiuyun Yu