Forum Discussion

ovetteabejuela's avatar
ovetteabejuela
Impactful Individual
9 years ago

Power Query: Update Statement Equivalent (SQL)

Hi Community and M Gurus!   Is there an equivalent syntax in Power Query where I can update existing records via "update" command?    
Need Help
GilbertQ's avatar
GilbertQ
Super User
9 years ago

Hi ovetteabejuela

 

If you are referring to when you Enter Data and you want to update the data?

 

If so then open the Query Editor, go to the table you created with the Enter Data.

Then under Applied Steps, where it says "Source" click on the Gear Icon.

You can now update, edit or delete data, rows or columns.

ovetteabejuela's avatar
ovetteabejuela
Impactful Individual
9 years ago

Hi GilbertQ & Anonymous,

 

I was actually referring to this (mysql) and an M/Power Query-equivalent

 

UPDATE [LOW_PRIORITY] [IGNORE] table_reference
    SET col_name1={expr1|DEFAULT} [, col_name2={expr2|DEFAULT}] ...
    [WHERE where_condition]
    [ORDER BY ...]
    [LIMIT row_count]

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    Hi ovetteabejuela,


    Power bi not exist equivalent function of update. In my opinion,I think you can add a custom column which the if statements, then delete the original column.

     

    Regards,

    Xiaoxin Sheng