Inscrivez-vous ou connectez-vous pour rejoindre votre communauté professionnelle.
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