Append data with every refresh of Salesforce Report

[powerbiusertest]

Hi,

  I am trying to pull report from Salesforce and creating a new table Table1 to append this data along with adding a new column Run Date in Table 1 which should capture the date report was loaded to table. 

I am using append queries to achieve this and i have below issues
1. Run date is updated with every refresh of report.

2. Data is not getting appended with every refresh.  Sometimes its partial. Is there a limit? My report doesnt have more than 2000 records.
I dont want to do incremental refresh since some of the records can be same with every refresh and i still want to load these records with the latest refresh.

Thanks!

[amitchandak]

@powerbiusertest , check if this DAX append method can help

https://blog.crossjoin.co.uk/2020/04/13/keep-the-existing-data-in-your-power-bi-dataset-and-add-new-...
https://www.thebiccountant.com/2017/01/11/incremental-load-in-powerbi-using-dax-union/