Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hello!
I have a question. How can I make a Table in Query Editor that can append another table to itself with every data refresh?
At first my Table is blank, after it justs put the new data after the old ones. Tha new data is coming from an Oracle Database and it's formatted and summed at the right places, and it has numeric, text and date types (with the exact same column names from the other table)
I have this so far:
let Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i44FAA==", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type text) meta [Serialized.Text = true]) in type table [Date = _t, #"LINK CODE" = _t, #"SUM RAM" = _t, #"SUM HDD" = _t, #"SUM CPU" = _t, #"SUM BEVETEL" = _t, Column1 = _t]), #"Changed Type" = Table.TransformColumnTypes(Source,{{"Date", type text}, {"LINK CODE", type text}, {"SUM RAM", type text}, {"SUM HDD", type text}, {"SUM CPU", type text}, {"SUM BEVETEL", type text}, {"Column1", type text}}), #"Renamed Columns" = Table.RenameColumns(#"Changed Type",{{"Column1", "Csomag"}}), // #"filled" = Table.InsertRows(#"Renamed Columns", rowCount_heti, Query1) #"TableCombine" = Table.Combine({#"Renamed Columns", Ossz }) in #"TableCombine"
But I have a strong feeling it will only put the last ones to the table.
I really hope that someone can help.
Thank you
Hi @lattys,
To append multiple tables with same table structure, a easy way is to use "Append query" option in Query Editor mode.
Regards,
Yuliana Gu
Thank you, but I can't use this, at least I don't think so. I need to repetedly add the fresh aggregated dates so it can expand with newer elements.
But I think I may be able to do this only from the servers (oracle) using some sql, it just would have been easier to edit it in Power Bi.
Hey i'm running into the exact same issue. Did you find a way to solve this?
User | Count |
---|---|
128 | |
109 | |
100 | |
65 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |