Power BI - Date Update

Hi Doubilo ,

My thought is that you can split your XLSX and the new date into different files, count the rows in advance in the different files, and import them into Power BI.
For example, if the first file is the latest date 2024-10-22, you can name the xlsx file name "2024-10-22", and there is a column with 100 rows in the table.
The second file is updated from 2024-10-22 to 2024-10-30, you can name the xlsx file name "2024-10-30", and there is a column with 20 rows in the table.
This way you can connect folders to get all the xlsx files and merge them, and they can also be processed based on the file name and the number of lines.

I've made a simple example of the data for your reference:

Below, you have combined it into a table and identified it by the file name, which you can name as the name you want.

Power Query Folder connector - Power Query | Microsoft Learn

Best Regards,

Stephen Tao

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