Edit dataset using R visual

[Paheli]

Hi!

i would like to know if we can edit dataset values by using R visual (and not R script in query)

For example : "dataset$values[i]=10" gives"unexpected input" as error

[v-shex-msft]

Hi @Paheli,

Based on error message, it think you inputted wrong script in r visual.

You can try to use below formula to modify specific element from data frame:

dataset[i,"values"] <- 10

Reference link:

R Data Frame

R-intro

Regards,

Xiaoxin Sheng 

[Paheli]

@v-shex-msft thanks for your reply but nothing happen when excute the code 

here below the screenshot:

[v-shex-msft]

Hi @Paheli,

According to your screenshots, I found you use '=' to replace '<-', I'm not so sure if character '=' can work as '<-' in r script.

Maybe you can modify it and try again.

Regards,
Xiaoxin Sheng

[Paheli]

Unfortunatley it doesn"t work even with <- or =

[otravers]

Try loading your code in R Studio and debug it there, it will be easier and that will rule out Power BI issues.

[Paheli]

@otravers

actually i us notepad to write my code and i test the code on powerbi because i try to edit a table within powerbi 

@v-shex-msft 

As a solution i plotted my tables on the R visuals it's a little bit limited because i can't select my data.

thank you for your reply