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

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

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
nelsoncruzg
Frequent Visitor

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.

Anonymous
Not applicable

Hi @nelsoncruzgI have pbix with RLS and working fine at service workspace but when i posted to MS Teams , seems the RLS is not working. is power bi supporting RLS at Teams ? is there any turnaround to work on the same? is power bi team working on to enable this mechnism in coming update ? Pls advice.

HarrisMalik
Continued Contributor
Continued Contributor

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

 

Report Hyperlink.jpg

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

jblack
Frequent Visitor

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

Any update on this enhancement yet? Thanks!

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

Any update on this feature? 

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

WillT
Power BI Team
Power BI Team

Hi! This is a great idea, we'll add it to the backlog and fix it in a future release. thanks!
Anonymous
Not applicable

Hi @WillT, I have pbix with RLS and working fine at service workspace but when i posted to MS Teams , seems the RLS is not working. is power bi supporting RLS at Teams ? is there any turnaround to work on the same? is power bi team working on to enable this mechnism in coming update ? Pls advice.

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.

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

Get Ready for Power BI Dev Camp

Power BI Dev Camp - June 24th

Mark your calendars and join us for our next Power BI Dev Camp!

Top Solution Authors
Top Kudoed Authors