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

8 REPLIES 8
Sean Super Contributor
Super Contributor

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




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

 

Highlighted
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

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

@raywilson426  Check your syntax, that does not work.

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Users Online
Currently online: 176 members 2,257 guests
Please welcome our newest community members: