Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Reply
Paheli
Frequent Visitor

Edit dataset using R visual

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

 

6 REPLIES 6
Anonymous
Not applicable

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 

@Anonymous thanks for your reply but nothing happen when excute the code 

here below the screenshot:

Capture_powerbi.PNG

Anonymous
Not applicable

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

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

otravers
Community Champion
Community Champion

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

------------------------------------------------
1. How to get your question answered quickly - good questions get good answers!
2. Learning how to fish > being spoon-fed without active thinking.
3. Please accept as a solution posts that resolve your questions.
------------------------------------------------
BI Blog: Datamarts | RLS/OLS | Dev Tools | Languages | Aggregations | XMLA/APIs | Field Parameters | Custom Visuals

@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 

 

@Anonymous 

 

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

Helpful resources

Announcements
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

December 2025 Power BI Update Carousel

Power BI Monthly Update - December 2025

Check out the December 2025 Power BI Holiday Recap!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.