How to edit a data field in a table

Question

I'm wondering if desktop allows me to edit individual cells of a dataset that was loaded from Excel?&nbsp;&nbsp;Thanks in advance

anonymous · Answer

Hi rdenicolo,
&nbsp;
Current, power bi not support directly to these operation when you get data, but you can modified these fields at query editor side.
&nbsp;
Reference;
Keep Range of Rows:
Table.Range( table as table, offset as number, optional count as nullable number) as table&nbsp;&nbsp;
&nbsp;
Table.SelectColumns:
Table.SelectColumns(table as table, columns as any, optional missingField as any) as table&nbsp;&nbsp;
&nbsp;
Regards
Xiaoxin Sheng

Forum Discussion

How to edit a data field in a table

Related content

Edit Table with Calculation Items

Edit table option is disabled while in editing mode

Displaying Table Fields as Rows in DirectQuery

Edit existing table values

SUMMARIZE, VALUES, and other table generation/manipuation with field parameters