Create a link to a PDF sharepoint file list

Hi,

I'm wondering which is the best solution to perform what follows:

I have a power BI report, as a matrix, based on an excel.

On this matrix, one column is a number of Purchase Order (PO) As example: 12345. For each one of this PO I have a PDF file that represent the SOW of the Purchase. These PDF are named as 12345.pdf and stored in a sharepoint directory (and a teams channel).

In this matrix, every day new PO are inserted and also in the sharepoint, various SOW PDF file are copied. 

I'm wondering how to create a direct link from the PBI report field "PO" to the PDF file in order to recall and open it directly. Of course I've taken into consideration the URL creation as a new column in the table, but the URL created by the Sharepoint once inserted the file is not previsible and not related to the PO number, so I have to insert the URL manually and cannot do it automatically.

I've solved adding a column in the excel where I mannually paste the URL extracted from the sharepoint, but it is a very manual and time-consuming solution.

Colleagues, do you have any idea? Maybe also using Power Automate as external helper?