Communiquez avec les autres et partagez vos connaissances professionnelles

Inscrivez-vous ou connectez-vous pour rejoindre votre communauté professionnelle.

Suivre

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.

user-image
Question ajoutée par Owais Akber , Senior Accountant , Modec Building Material Trading LLC
Date de publication: 2017/02/06
Ibrahim Fazal
par 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
par ihtisham LATIF , OPERATION MANAGER , MCB BANK LTD

go to insert filed and add row

More Questions Like This