Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

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

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
Anonymous
Not applicable

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 @Anonymous, 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.

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.

Anonymous
Not applicable

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
Community Admin
Community Admin

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
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.