Register now or log in to join your professional community.
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.
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"})
go to insert filed and add row
