Bayt.com

Start networking and exchanging professional insights

Register now or log in to join your professional community.

Follow

Adding Rows in existing table in Power BI?

Any one knows how to add rows of data in existing table in Microsoft Power BI? My excel file from which I have added data earlier is very heavy now and I can not add more data in that file to update power bi data model. I need some way to add data from a separate excel file in an existing data model.

Microsoft Technologies Analysis Data Management Data Analysis Database
user-image
Question added by Owais Akber , Senior Accountant , Modec Building Material Trading LLC
Date Posted: 2017/02/06
Upvote (1) Views (24) Followers (3) Answers (2) Report Question
Write an Answer
Register now or log in to answer.
Ibrahim Fazal
by Ibrahim Fazal , Lead Database , MTBC

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

ihtisham LATIF
by ihtisham LATIF , OPERATION MANAGER , MCB BANK LTD

go to insert filed and add row

Write Your Answer
More Questions Like This

Do you need help in adding the right keywords to your CV? Let our CV writing experts help you.

Get Help