Create a new row

[Daven]

Hi,

I need to manually add a raw to table that is pulling data from SQL.

Is there a way to create a row under the transform data once the data is loaded? 

Thanks,

Daven

[Pragati11 · Accepted solution]

Hi @Daven ,

You can check this Insert row option in query editor to add the row after you have loaded data:

https://docs.microsoft.com/en-us/powerquery-m/table-insertrows

Thanks,

Pragati