Power BI - Date Update

[Doubilo]

Hi everyone, 

I need your help. I have xlsx source for Power BI whitch is automatickly updates but update date is not includs data source. I need  update date load to the table like new column for the next work

Example: update date is 2024-10-22 (cw43), count of rows is 100

 next update date is 2024-10-30 (cw44), in source is now 120 rows because there is 20 rows new

I want to create table where will be:

CW 43     100

CW 44     120

[Anonymous]

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.

[Omid_Motamedise]

you can use week number and then group data based on the week number

[lbendlin]

Power BI has no memory* . You need to manage your snapshots in the upstream system. * Yes, there is the self referencing option but that has no safety net.

You can use the file Last Modified Date for that data point. Beware - it does not necessarily mean that the actual data is updated. All it means is that the file was modified.