adding rows

[Anonymous]

Hi,

 Request your guidance to solve this issue of mine

In PBI  GET DATA   selected WEB and got the data loaded,  I would like to add a new row for  which iam not able to find a way, please guide me how to do this 

regards,

dsmitha 

[tackytechtom · Accepted solution]

Hi @Anonymous ,

You can add a row in Power Query with the Table.InsertRows command.

Here an example that you can paste into the advanced editor after you have aadaoted it to your case. I made the row in question bold.

= let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WMlTSgWB9Q30jIyDDFIiDUlOUYnUgkiAxI5ikoQGQcC9KTc2DyxsDsQlcM6q8EdRwY7h+kOlOOaWpcGmwLpi0kQFcOhYA", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [#"Project #" = _t, #"Job #" = _t, Date = _t, Count = _t, Category = _t]),
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"Project #", Int64.Type}, {"Job #", Int64.Type}, {"Date", type date}, {"Count", Int64.Type}, {"Category", type text}}),
    #"Renamed Columns" = Table.RenameColumns(#"Changed Type",{{"Job #", "Job"}, {"Project #", "Project"}}),
    #"Custom1" = Table.InsertRows(#"Renamed Columns",0, { [Project = 99, Job = 99, Date = "31/12/2022", Count = 99, Category = "Green"] })
in
    #"Custom1"

Here the result (the first row was the one which was appended afterwards):

Let me know, if this works for you 🙂

/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/

[Anonymous]

Hi tomfox,

Thanks a ton, it worked perfectly 

regards,

dsmitha