Solved: Using R in Query Editor - Page 2

MPereira · ‎12-26-2018

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-running-an-R-script-in-Power-Query. The error stopped happening, however the CompletedValues column did not appear in my fields panel.

Captura de Tela 2018-12-26 às 13.59.46.png

Captura de Tela 2018-12-26 às 14.00.02.png

Captura de Tela 2018-12-26 às 14.00.13.png

Anyone have any idea what might be happening?

I downloaded the final .pbix file provided by the article, but the same problem occurs!

Please, help me.

Best regards,

Marcelo.

AlexisOlson · ‎01-04-2019

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 = ",")

View solution in original post

Using R in Query Editor

Helpful resources

Microsoft Fabric Learn Together

Power BI Monthly Update - April 2024

Fabric Community Update - April 2024

How to Get Your Question Answered Quickly