cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
vitexo87 Member
Member

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

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

7 REPLIES 7
Super User
Super User

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

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

 

vitexo87 Member
Member

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

This is the only means?

Super User
Super User

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

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

Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

Imke Feldmann

How to integrate M-code into your solution -- Check out more PBI- learning resources here -- Performance Tipps for M-queries




vitexo87 Member
Member

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

@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?

Untitled.png

Super User
Super User

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

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... ).

Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

Imke Feldmann

How to integrate M-code into your solution -- Check out more PBI- learning resources here -- Performance Tipps for M-queries




Highlighted
KevinSanDiego Frequent Visitor
Frequent Visitor

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

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

 

raywilson426 Frequent Visitor
Frequent Visitor

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

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