How do I edit a table to add a row or field to an existing table in Power BI Report Builder?

[HamidBee]

I am using Power BI report builder. I have created a table with some row groups and values. I created a new field and I'd now like to add it into my existing table but I cannot figure out how to edit the table. Does anyone know how I can edit an existing table to change the row groups, values and column groups in Power BI report builder?

Thanks

[v-luwang-msft]

Hi @HamidBee ，

Pls see the below screenshot:

1. Double click the dataset

2. Click the query designer

Did I answer your question? Mark my post as a solution!

Best Regards

Lucien

[HamidBee · Accepted solution]

Unforurtunately I can't verify if this is right or wrong. I am using SQL to query my data. But I have figured out that I can simply right click on the actual grey area within the table matrix to add and remove columns. i.e. change the layout and then click the blue icon/s in the table to change the field/s.