I have a dataset in power BI that I want to analyse using an R-script. I add the script from this procedure:https://docs.microsoft.com/en-us/power-bi/desktop-r-in-query-editorBut when testing with a script that is not supposed to change anything (contains only "output <- dataset") the output is different from my original table. Column content is mixed all over the place, rearranging the entire table.
This turns out to be a powerBI bug, where newlines and carriage returns are not handled ok. So if these are removed first, the script works ok. Please add comments if you have experienced the same with other symbols too.