Only import the first date from multiple files

Hi ipon70 

For your question, here is the method I provided:

Here's some dummy data

"Table"

"Table (2)"

"Table (3)"

First, import the data into power bi desktop, click "Transform Data" in the data loading interface to enter the power query.

Add an index column for each table. Make sure your date columns are arranged from smallest to largest, if not you can adjust them manually.

Select "Append Queries".

Generate the table below:

Filtering "Index" equal to 1.

Click on "Close & Apply" and you can also remove the index column to avoid the impact. Here is the result:

Regards,

Nono Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.