Reply
Member
Posts: 336
Registered: ‎03-17-2016

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

Super Contributor
Posts: 2,146
Registered: ‎08-11-2015

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.

 

Member
Posts: 336
Registered: ‎03-17-2016

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

This is the only means?

Super User
Posts: 1,564
Registered: ‎09-06-2015

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




Member
Posts: 336
Registered: ‎03-17-2016

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

[ Edited ]

@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
Posts: 1,564
Registered: ‎09-06-2015

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

[ Edited ]

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
Frequent Visitor
Posts: 4
Registered: ‎10-06-2017

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

 

Frequent Visitor
Posts: 2
Registered: ‎04-22-2018

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