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
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!

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
Coming Soon: T-Shirt Design Contest

Coming Soon: T-Shirt Design Contest

Keep your eyes open for our upcoming T-shirt design contest!

Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

Super User Challenge: Can You Solve These?

Super User Challenge: Can You Solve These?

We're celebrating the start of the New Super User season with our first ever Super User 'Can You Solve These?' challenge.

Power BI Desktop Update - February 2020

Power BI Desktop Update - February 2020

We are super excited for our update this month, as we are releasing two of our top community requests!

Power Platform Online Conference

Power Platform Online Conference

Join us for the first ever Power Platform Online Conference!

Top Solution Authors