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. Yes you can build something like that. You have to be sure that the pdf link is accesible by the user. Maybe a sharepoint would do the job. The data should be something like PdfName | LinkToPdf . They are different columns and will be different in table too. If you add a link to a table you can categorize it as "URL" in format options for the column. That way you will be able to click on it as a link. You can also change format options in the table to use a little icon instead of the big link to the pdf.
You can see an example of a table with links here: https://www.ladataweb.com/informes.html?id=movie
Hope this helps,
Hi
Thanks for your reply, maybe i missed somthing but it doesn't seems to work on my side
On first column i have invoice number
On second column i have the path of where the pdf is + name of the pdf but i can't openned it