Forum Discussion

erickulcyk's avatar
erickulcyk
Microsoft Employee
10 years ago

hyperlinks in table

Hello,

 

Is there a way I can post hyperlinks in a database, and have them show up in a table and be clickable in powerbi?

 

Thanks,

Eric

Need Help

19 Replies

  • Alex_J_Potter's avatar
    Alex_J_Potter
    Advocate I
    10 years ago

    You just need to cast the data type for the URL in your data model - its super quick. 

    1. Navigate to the data model tab in Power BI Desktop
    2. Select the column that contains the URLs
    3. Under "Data Category" in the Modeling tab, select "Web URL"
     
    After that, the URLs should show up blue and clickable in any table you place them in.
    • aroca's avatar
      aroca
      Advocate I
      9 years ago

      Yes, but is there a way to do like <a href="http://www.website.com">click here</a>. The problem with the hyperlinks is that they can be very, very long and we don't want to show the whole query. Thanks!

      • maccaronda's avatar
        maccaronda
        Frequent Visitor
        9 years ago

        Did you ever get an answer this by any chance? I would also like to use hyperlinks but some of the URL's are 60 characters or more. Not great on a dashboard!

        Thanks

  • Anonymous's avatar
    Anonymous
    Not applicable
    10 years ago

    The only hyperlink functionality that I'm aware of resides in the text box. Fields in the table or matrix are not selectable in any state, so it's hard to see at the moment how there would be any work around for this right now..

  • skaratela's avatar
    skaratela
    Frequent Visitor
    8 years ago

    Hi all,

     

    Does anyone know why the 'Properties' section onder the Modelling tab is greyed out? As this is greyed out I cannot set my column as URL type.  I have imported the data into PowerBI as opposed to DirectQuery.

     

    Cheers

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hello is it possible to add hyperlink on any row inside the table column. Example on items price or name of the company in the list.

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Anonymous 

      I copied this from the article on hyperlinks in tables. 

       

      Q: Can I use a custom URL as a hyperlink in a table or matrix?
      A: No. You can use a link icon. If you need custom text for your hyperlinks and your list of URLs is short, consider using a text box instead.

       

      So, for now, the answer is no.  But I searched ideas.powerbi.com and saw a few other people with this same request.  Add your vote to get the product groups attention 🙂

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    My matrix table is also showing a hyperlink on the totals and adding a "First' label to my column header. is there a way to remove the url for totals? the url connects to a single contact record on crm. what is happening here is that for 'Girls' category it is pulling the url for the first person in that category and sticking it in my crm record details. I want to show a blank instead. I only want to show a url where youth is 1. Thanks in advance for the help.