Forum Discussion

rdenicolo's avatar
rdenicolo
New Member
9 years ago

How to edit a data field in a table

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

 

Thanks in advance

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable

    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