Load an excel from sharepoint but the last caracters of name file changes depending of the day

[lmfernandez]

Hello,

I have to load to Power Bi  an excel that is located in Sharepoint.

For example, the path is this:
https://example.sharepoint.com/sites/group/Shared Documents/General/PLANIFICACION/T3G_PLA_CdM_Planificacion-1234.xlsx

The problem is that the bold font part of the xlsx file name changes with the time.

For example, today this file can name T3G_PLA_CdM_Planificacion-1234.xlsx, but tomorrow it can be T3G_PLA_CdM_Planificacion-8541.xlsx

I have tried using the path with regular expression like this but it doesnt work:

https://example.sharepoint.com/sites/group/Shared Documents/General/PLANIFICACION/T3G_PLA_CdM_Planificacion-.*.xlsx

I need to say to Power Bi that get the data that begins with T3G_PLA_CdM_Planificacion- ignoring the last caracters.

Is there any way to do that?

Thank you in advance

Regards

[v-janeyg-msft · Accepted solution]

Hi, @lmfernandez 

Do you want to get the latest date data based on the file name? If so, you can set parameters in PQ to customize the file name.

Like this:

After setting, you can manually select the file name you want.

If you still have problems, please feel free to ask me.

Best Regards

Janey Guo

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

[mahoneypat]

There are a few ways to do that.  Are the files from the previous day still there?  Here are two suggestions:

1.  Use a Power Automate flow that is triggered when a new file is created, renaming the new file and then pointing Power BI at the file with that name.

2.  You can sort your query off the created date of the file, or you can use the Table.MaxN function to keep the top one in terms of created date.

Pat