Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
Solved! Go to Solution.
Hi @Lobojo ,
Please check if this document is helpful.
https://docs.microsoft.com/en-us/power-query/connectors/sharepointfolder
Best Regards,
Jay
Hi @Lobojo ,
Please check if this document is helpful.
https://docs.microsoft.com/en-us/power-query/connectors/sharepointfolder
Best Regards,
Jay
Yes, creating a query to the sharepoint folder and then a link to the files. Perfect
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
99 | |
80 | |
64 | |
57 |
User | Count |
---|---|
145 | |
110 | |
91 | |
84 | |
66 |