cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
trebgatte Established Member
Established Member

Any way to render an email address as a clickable link in a report?

I've created an exception type report where the normal next action is to send an email to the person with the exception. In Excel, I have the hyperlink function where I can create a clickable link which has a preconfigured subject and short intro to which I append data from the report, so that the process is expedited. It makes the visualization feel more interactive and places it at the center of the workflow.

 

Is there some way to do this in PowerBI Designer report? I built a formula to do this but it renders as plain text. There's no HTML column type that I can see.

 

For example:

="<a href=&quot;mailto:"&[ResourceEmailAddress]&"?subject=Process%20Exception&body=This email is being sent regarding this exception: "&[Description]&"&quot; >Email</a>"

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Power BI Team mllopis
Power BI Team

Re: Any way to render an email address as a clickable link in a report?

Hyperlinks are coming in July but won't work for mailto:// links, only for http or https.

 

As WillT pointed out, we're adding this to our backlog for a subsequent update.

 

Thanks,
M.

View solution in original post

11 REPLIES 11
Moderator WillT
Moderator

Re: Any way to render an email address as a clickable link in a report?

Hi! This is a great idea, we'll add it to the backlog and fix it in a future release. thanks!
trebgatte Established Member
Established Member

Re: Any way to render an email address as a clickable link in a report?

Wouldn't the data categorization feature enable this? http://community.powerbi.com/t5/Designer/Data-Categorization/m-p/364#U364 Marking the column as web url might be all that is needed.

HarrisMalik Established Member
Established Member

Re: Any way to render an email address as a clickable link in a report?

HI, it looks like hyperlink support will be available from 24th July

 

Report Hyperlink.jpg

Power BI Team mllopis
Power BI Team

Re: Any way to render an email address as a clickable link in a report?

Hyperlinks are coming in July but won't work for mailto:// links, only for http or https.

 

As WillT pointed out, we're adding this to our backlog for a subsequent update.

 

Thanks,
M.

View solution in original post

xuxueqing Occasional Visitor
Occasional Visitor

Re: Any way to render an email address as a clickable link in a report?

Any update on this enhancement yet? Thanks!

praveenudu Occasional Visitor
Occasional Visitor

Re: Any way to render an email address as a clickable link in a report?

Anyupdate for supporting mailto:// links, to work instead of http or https.?

jcorbett Frequent Visitor
Frequent Visitor

Re: Any way to render an email address as a clickable link in a report?

Any update on this feature? 

Also, is it possible to display alternative text for the hyperlink, so I don't have to have https://? 

nelsoncruzg Frequent Visitor
Frequent Visitor

Re: Any way to render an email address as a clickable link in a report?

Hi Guys..

 

This is on the roadmap. Currently under implementation according to this idea.

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/11419782-allow-mailto-hyperlinks-...

 

Let's see when is coming.

jblack Frequent Visitor
Frequent Visitor

Re: Any way to render an email address as a clickable link in a report?

As mailto links are now availaible, is there a way to have the body of the message populate with interactive data from the report?

Helpful resources

Announcements
October 2019 Community Highlights

October 2019 Community Highlights

October was a busy month in the community. Read the recap article to learn about some of the events and content.

New Solution Badges

New Solution Badges

Two waves of brand new solution badges are coming! Read the article for more information on our new community badges.

Ask Amir Anything

Exclusive LIVE Community Event No. 2 – Ask Amir Anything

Next in our Triple A series: Ask Amir Netz questions about the latest updates, features and future.

Analytics in Azure virtual event

Analytics in Azure virtual event

Experience a limitless analytics service built to ingest, prep, manage, and serve data for immediate use in Power BI.

Users Online
Currently online: 170 members 1,898 guests
Please welcome our newest community members: