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

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,

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Now with the file protocol i got a small windows, with a finger pointing on it when i click on it

    However nothing opened when clicking. I think the issue is stemming from the file protocol.

    i currently using 

    file:///10.64.17 etc

    I think we are getting closed 🙂

     

     

    • v-robertq-msft's avatar
      v-robertq-msft
      Community Support
      5 years ago

      Hi, Anonymous 

      According to your requirement, you can place your pdf files to onedrive for business and create links to access the pdf files, and insert these hyperlinks into your table, you can follow my steps:

      1. Place your pdf files to onedrive for business and create links to access the pdf files, like this:

       

       

      1. Create a table, contains pdf file name and links, like this:

       

      1. Change the [pdf] column category, like this:

       

      1. Show this table in a table chart and change the link visual, like this:

      You can download my test pbix file here

      And you can get what you want.

       

      Learn more about adding hyperlinks (URLs) to a table or matrix

       

      Best Regards,

      Community Support Team _Robert Qin

      If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

      • Anonymous's avatar
        Anonymous
        Not applicable
        5 years ago

        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