Forum Discussion

telusive's avatar
telusive
Frequent Visitor
2 years ago
Solved

Exporting Hyperlink URLS to Power Bi From Excel?

Hello all! Thanks for your help. I am currently connecting to a 'webpage' of excel that is being used live by some employees. They have a hyperlink to folders on their own computers that just say li...
  • Ritaf1983's avatar
    2 years ago

    Hi telusive 
    To reach the goal you need to apply these steps :

    1. In Excel you need the links will be text data type with the original link and not "saved there"
    2. make sure that the hyperlinks are in the needed format :
    Column1

    file:///C:/Users/RitaFainshtein/Downloads/pedro.pbix

    3. With Power BI desktop modify the column as a web URL:

    4. You can let it look just with an icon :

    Note that on the Power BI desktop, it will not open, just from the service.

    5. To make it work from the service you need to add to Chrome the option of "enable local file links"

    That's all 🙂 just publish.
    For more information see this blog post:

    https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-may-feature-summary/#urlTables

    If this post helps, then please consider Accepting it as the solution to help the other

    members find it more quickly