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...
Need Help
Tutorial Requests
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 !!!

  • v-easonf-msft's avatar
    v-easonf-msft
    Icon for Community Support rankCommunity Support
    6 years ago

    Hi, Anonymous 

    Could you please tell me whether your problem has been solved?
    If yes, you could accept the helpful answer as solution ro close this thread . So that other community members will easily find the solution when they get the same issue.You also could share your own solution here.

    For now, there is no content of description in the thread. If you still need help, please share more details to us.

     

    Best Regards,
    Community Support Team _ Eason