How to connect power bi share point folder and refresh only lastest 5 files from that folder

[TriveniN]

I need to connect power bi share point folder and refresh only lastest 5 files from that folder and file names like below from folder.

Labour cube - 2024.07 Jul.xlsx

Labour cube - 2024.06 May.xlsx

Labour cube - 2024.04 Apr xlsx

Labour cube - 2024.03 Mar.xlsx

Labour cube - 2024.02 Feb xlsx

Labour cube - 2024.01 Jan.xlsx

Labour cube - 2023.12 Dec.xlsx

Kindly Let me know if any suggestions are there?

[bhanu_gautam]

@TriveniN , Go through this video

https://youtu.be/hpWOxDz4OKg?si=0dHg0ofnybR697xn

Add a filter to include only files that match the pattern "Labour cube - YYYY.MM MMM.xlsx".
Click on the drop-down arrow in the Name column.
Select Text Filters > Contains.
Enter "Labour cube" and click OK.
Sort Files by Date:

If your file names include the date in a sortable format (e.g., YYYY.MM), you can sort by the Name column.
Otherwise, sort by the Date modified column.
Click on the drop-down arrow in the Date modified column.
Select Sort Descending.
Keep Only the Latest 5 Files:

Use the Keep Top Rows function to keep only the latest 5 files.
Go to the Home tab.
Click on Keep Rows > Keep Top Rows.
Enter 5 and click OK.