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
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