cancel
Showing results for 
Search instead for 
Did you mean: 
Reply

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
Power BI Team WillT
Power BI Team

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!

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 Continued Contributor
Continued Contributor

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
New Member

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

Any update on this enhancement yet? Thanks!

Highlighted
praveenudu
New Member

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

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

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

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
New Ranks Launched March 24th!

New Ranks Launched March 24th!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power BI Community!

‘Better Together’ Contest Finalists Announced!

‘Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

Arun 'Triple A' Event Video, Q&A, and Slides

Arun 'Triple A' Event Video, Q&A, and Slides

Missed the Arun 'Triple A' event or want to revisit it? We've got you covered! Check out the video, Q&A, and slides now.

Join THE global Microsoft Power Platform event series.

Join THE global Power Platform event series.

Attend for two days of expert-led learning and innovation on topics like AI and Analytics, powered by Dynamic Communities.

Community Summit North America

Community Summit North America

Innovate, Collaborate, Grow. The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors