Forum Discussion
Open Attachment Power BI
I understand that you need massive links. You can do this with Sharepoint.Contents function in power query like this post:
https://blog.ladataweb.com.ar/post/627427136962281472/powerbi-obtener-datos-de-una-carpeta-de
That post shows you how to navigate in sharepoint. When you get in the folder with the files check the last column. It is "folder path", it looks like:
https://[company].sharepoint.com/sites/[SiteName]/[FolderName]You can concatenate that string with the column "Name" containing the file name to create a download link for that file. That way you have create all link with power query conditions that can be used in the table as download. Like
https://[company].sharepoint.com/sites/[SiteName]/[FolderName]/file_name_from_column_name.pdfHope that helps
Hi
Many thanks for your input and help.
However, i'm not sure that working with a sharepoint will be the best solution
On the table i will have more than 10K lines and for each line it will be a different PDF, and on top that there will be new PDF every morning that the guy have to check.
So i will have to copy the 10k link from sharepoint and the table will not be updated every morning,
So that is why i'm more looking at a local server with name that i can combine with the pdf.
for instance the path is \\10.64.189.54\C\Invoices\10203040.pdf
In the file i will put a column with invcoie number
and another column with the path combine with PDF in order to make it dynamic
Thanks
I understand that you need massive links. You can do this with Sharepoint.Contents function in power query like this post:
https://blog.ladataweb.com.ar/post/627427136962281472/powerbi-obtener-datos-de-una-carpeta-de
That post shows you how to navigate in sharepoint. When you get in the folder with the files check the last column. It is "folder path", it looks like:
https://[company].sharepoint.com/sites/[SiteName]/[FolderName]
You can concatenate that string with the column "Name" containing the file name to create a download link for that file. That way you have create all link with power query conditions that can be used in the table as download. Like
https://[company].sharepoint.com/sites/[SiteName]/[FolderName]/file_name_from_column_name.pdfHope that helps
That is working you Rock !!! Thanks