Forum Discussion
Solved
Append older data to new live data
I have 2 tables in my Power BI solution. One is based on a query to a live MySql database and has columns a,b,c,d,e,f..... the other table is just some historical data that I copied in from Excel. ...
Try using Append Queries rather than Merge Queries.
https://docs.microsoft.com/en-us/power-query/append-queries
What I did is create a summary table from the live data and now I want to append this to the historical table.
Both only contain 2 columns, reportyear and premiumwritten. However, when I go into Merge Queries the summary table is not available to append. Can you not append to a summary table in Power BI?
Try using Append Queries rather than Merge Queries.
https://docs.microsoft.com/en-us/power-query/append-queries