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

July 7 - July 17 | Round 2 of the Power BI Dataviz World Championships. Don't miss your chance! 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
FabCon and SQLCon Barcelona 2026

FabCon & SQLCon – Barcelona 2026

Join us in Barcelona for FabCon and SQLCon, the Fabric, Power BI, SQL, and AI community event. Save €200 with code FABCMTY200.

July Power BI Update Carousel

Power BI Monthly Update - July 2026

Check out the July 2026 Power BI update to learn about new features.

60 days of Data Days Carousel

Data Days 2026

Join Data Days 2026: 60 days of free live/on-demand sessions, challenges, study groups, and certification opportunities.

Power BI DataViz World Championships carousel

Power BI DataViz World Championships - June 2026

A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.

Top Solution Authors