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
Thanks!