Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

PowerBi Table not recognising mailto as a URL

Hey 

 

I've been trying to get a mailto link to work in a PowerBi table, ideally with the URL Icon. This is pulling through from a Sharepoint Excel, the mailto link is made in a CONCAT function. An example is below:

 

 

mailto:[email protected]?subject=UK%20Capabilities%20Catalogue

 

 

According to Microsoft docs, PowerBi should recongise the following URLs, I've tried -mailto, :mailto, mailto etc. to no avail. -https://docs.microsoft.com/en-us/power-bi/create-reports/power-bi-hyperlinks-in-tables:

 

URLS must start with one of the following 

http
https
-mailto
file
ftp
news
telnet

 

 

The link isn't clickable in the report at all.

Need Help
Tutorial Requests

6 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Icon for Community Champion rankCommunity Champion
    6 years ago

    Anonymous - mailto works just fine but you need to drop your query string.

  • Anand24's avatar
    Anand24
    Icon for Super User rankSuper User
    6 years ago

    Hi Anonymous ,

     

    Go to Data and change the data type of column1(from your imagein previous comment) to WebURL.

    Also, format for mailing should be mailto:email_ID (Example- mailto:[email protected]) which i guess you already have.

     

    Check the below image to understand what i did and this works pretty perfectly with 1 click:

     

    You can also go to Format -> Values -> Enable URL Icon to show email icon instead of clickable text.

     

    Give a thumbs up if this post helped you in any way and mark this post as solution if it solved your query !!!

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Hi Anand24 ,

       

      Thanks for your response! Unfortunately as I am on Mac I am working on PowerBi Webapp, not desktop. I do not have access to the data category option!

      I have tried formatting the values to appear as URL, and I have tried the web icon. However, this does not work 😞

       

      Matthew

      • Anand24's avatar
        Anand24
        Icon for Super User rankSuper User
        6 years ago

        Hi Anonymous ,

         

        I don't think changing datatype and setting it to URL is possible from Power BI Services. You will have to perform those in Power BI Desktop.

         

        Also, pulling data from excel/sharepoint excel makes PowerBI pull data as text and not link. That's why even if you might have concatenated field as link in excel, it won't be recognised in Power BI.

         

        Suggestion: Download your pbix file from services, make required data type URL changes from desktop and publish back to services.

         

        Give a thumbs up if this post helped you in any way and mark this post as solution if it solved your query !!!