How to load the latest / oldest rows only?

[KH_Mike]

Hi All,

I have few Excel file which load into PBI. They have a Key field. May I know any way to load the latest / oldest by Key field or Excel created date?

Like below two Excel file, how can I only load "Excel A" first and if "Excel B" contain same key then ignore those row in "Excel B" vice versa?

Excel A

Key	Type	Amount
AAA	Apple	10
BBB	Apple	12
CCC	Apple	13

Excel B

Key	Type	Amount
AAA	Apple	10
BBB	Apple	9
CCC	Apple	8

[Anonymous · Accepted solution]

Hi　Mike，

If the amount of data no big, you can import two tables through PQ, table B matches table A through key, table B filters the unmatched data, and then you can add the filtered table B to table A. If the amount of data is large, it is recommended to add ETL.

[amitchandak]

@KH_Mike , for the created date you can set up incremental ETL  and schedule that on power bi service. if that can help. The same file should get updated

Incremental Load
https://radacad.com/all-you-need-to-know-about-the-incremental-refresh-in-power-bi-load-changes-only
https://thinkaboutit.be/2020/02/how-do-i-implement-an-incremental-refresh-in-power-bi-free-or-pro/