Adding a row in the table after it has been loaded?

[vitexo87]

I need to add a line in my table however'm not finding a way to do this after the load it has been made

[raywilson426]

Adding to the old post!

#"Insert Row" = Table.InsertRows(#"Prior Label/Step" = {[column1 = "dataA", column2 = "dataB", column3 = "dataC"]})

https://msdn.microsoft.com/en-us/query-bi/m/table-insertrows

-Ray

[RobertSlattery]

@raywilson426  Check your syntax, that does not work.

[Anonymous]

Here is the correct Syntax

 #"Insert Row" = Table.InsertRows(#"Previous Step Name", 0 (This is the offset),{[Column 1= "data1", column2= "data2",......column27 = "data27"]})

[KevinSanDiego]

I know this is an old post but I did find the solution on another post so I'll reference it here just in case someone else comes across this post and not the other one:

https://community.powerbi.com/t5/Desktop/Adding-a-row-manually-to-manually-created-table/td-p/58154

[Sean]

If you need to add more rows of data you need to add it to your source and then refresh.

[vitexo87]

This is the only means?

[ImkeF]

Actually, you can define a table in the query editor and append that to your other table:

Table.FromRows({{1, "Bob", "123-4567"} , {2, "Jim", "987-6543"}}, {"CustomerID ", "Name", "Phone"})

https://msdn.microsoft.com/en-us/library/mt260791.aspx

[vitexo87]

@ImkeF

I'm trying to apply your suggestion however I'm not getting the Power BI accuses error in the script, how could I apply your suggestion in my code?

[ImkeF]

You need to fill in your data at the respective places. I think a look into the documentation will give you some guidance here.

If you are a beginner, it would probably be easiest to create a separate table and append (like here: https://support.office.com/en-ie/article/Append-queries-Power-Query-e42ca582-4f62-4a43-b37f-99e2b2a4... ).