How to edit a data field in a table

[rdenicolo]

I'm wondering if desktop allows me to edit individual cells of a dataset that was loaded from Excel? 

Thanks in advance

[Anonymous]

Hi @rdenicolo,

Current, power bi not support directly to these operation when you get data, but you can modified these fields at query editor side.

Reference;

Keep Range of Rows:

Table.Range( table as table, offset as number, optional count as nullable number) as table  

Table.SelectColumns:

Table.SelectColumns(table as table, columns as any, optional missingField as any) as table  

Regards

Xiaoxin Sheng