Forum Discussion
Exchange Rate Update daily and Incremental
Hi, fabiopaturzo
use append table in power qury.
see the doc Append queries - Power Query | Microsoft Learn
sure. I did try this one with a sample example. looks like it is rewriting the row as the append table is updating, not adding new rows. But then I thought that it is supposed to work like that.
So, you need to use a DB actually to store data on a daily basis. use SSIS or may be can use Azure logic app to push the data. It is suggested that you use DB for long term data storage.
Where is the example?
This is the sample data I created as per your question.
the table that will update the date regularly.
Destination table. assumed there are some historical saved previously some other way.
then loaded it into the Power Query. As two tables structure is same, we do append, so I tries to use Append functionality but noticed that the value is also changing in the destination table as the value changes in the other table. Then I thought PQ is not designed to store information, you need to use a DB for long term data saving.