Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Open Attachment Power BI

Hi Everyone 

 

I'm trying to implement a tool for my team, through Power BI.

The idea is to have a simple table where they can so some search and link this table to a folder with several PDF.

The user will simply have to click on the PDF name and it will open directly 

 

Will it be possible, i didn't find any solution on Internet so far 

 

Thanks

Need Help
Tips and Tricks
  • ibarrau's avatar
    ibarrau
    5 years ago

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

    Hope that helps 

9 Replies

  • ibarrau's avatar
    ibarrau
    Super User
    5 years ago

    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,

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      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  

       

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Ok i Finally managed to do it throug a sharepoint

      However as we have more than 10k invoices to link to this it will be complicated to do everything with this solution

       

      Do you think we can do it through a local server ? We allready have all the invoices sitting somewehre on our Servers.

       

      Thanks

      Romain

      • ibarrau's avatar
        ibarrau
        Super User
        5 years ago

        Mmm... I'm not sure. Assuming the user already have a conection established to the shared local server. I'm thinking out loud now, if you use the file protocol to build the URL and that might work but it will open a browser and ask to download the file instead of open it. The feature will open things in browser. It might depend on how the user browser is configured because sometimes they open and read the pdf and sometimes they download it.

        Hope this thought helps.

        Regards,