Forum Discussion

svishwanathan's avatar
svishwanathan
Helper III
8 years ago

Adding row to an existing table

Hello

 

I want to add a few rows to a table that contains abour 70 rows of data. This report is based of  a power pivot model that I imported into Power Bi so I cannot update the source

 

I want to learn how to add new rows because I anticipate similar request in future where users want to update some records which were previously on spreadsheets

 

I added this 

#"Insert Row" = Table.InsertRows(#"Replaced Value3" = {[Client_Code= "dataA", Account Name = "dataB", Category = "dataC", Account Executive="xx"]})

 

I get this error

 

 

Need Help

1 Reply

  • MFelix's avatar
    MFelix
    Super User
    8 years ago

    Hi svishwanathan,

     

    I believe that the best solution is to get the information on an excel file / CSV File / Excel Table and then add it to your model making a append to your current data.

     

    In the below example I'm making it on a separate query and then appending it but you can also change the query in order to do all the source and append on a single query.

     

     

    Model was taken out from an import form a power pivot on excel.

     

    Regards.

    MFelix