Forum Discussion
Solved
Using R in Query Editor
Hello experts, I need to understand how to run an R script in Power BI and I found the link desktop-r-in-query-editor. At first the script did not work, until I found the post Error-in-r...
To me it looks like you aren't referencing the missing values column of completedData correctly.
When you load the data using dataset <-read.csv, by default it replaces the spaces within column names with periods. In particular, "SMI missing values" becomes "SMI.missing.values" so the last step in the R script doesn't do anything since it refers to a nonexistant column.
There are two easy fixes. Pick one or the other but not both.
- Change the last line.
output$completedValues <- completedData$"SMI missing values"
output$completedValues <- completedData$"SMI.missing.values" - Add an argument to read.csv to prevent this replacement.
dataset <- read.csv (file = "<path>", header = TRUE, sep = ",")
dataset <- read.csv (file = "<path>", header = TRUE, check.names=FALSE, sep = ",")
- Change the last line.
Did you change the R script at all? I can't reproduce what you're seeing.
Try Refresh Preview on the Home tab just in case it cached something wrong too.