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?
