Millington Offices (10).png

Send emails from Power BI – ask for updates on specific business metrics

Updated: Dec 1, 2020

If you use Power BI for data driven decision making you probably had the need to ask a client/supplier/user for updates on specific key metrics from your report.

You might be thinking now “Oh, but you can add comments in reports and dashboards…”, but what if the person you want to contact doesn’t have access to this specific report? What if you want to send an email asking for updates?

That’s where DAX hyperlinks come into play!

We will go through how you can easily add a hyperlink to a table that will automatically open a pre-defined email with all your main information (with a little caveat, the email won’t be automatically formatted, sorry folks ☹).

Just click send!

Key words: Power BI, DAX Hyperlinks, mailto

1) As an example, I used a dataset I found online with some info on Leeds Schools.

First, I built my table with the information I wanted to see.

Now, what we want to do is, instead of having the email column in my table, I want it to be a link that I’m able to click, and that will open a new window with a personalised email for me.

2) We are going to add a new column (I named it Mailto) where we will define what we want in our email.

You might now already that the mailto function opens a new email window based on the selection you’ve made on the table. But what, maybe, you didn’t know yet is that you can add users on CC, an email subject, and also define the body of the email using data from Power BI.

This is what the measure for my new Mailto column looks like:

Mailto = "mailto:" & 'Leeds Schools Info'[Email] << TO

& "?cc=" & ";" & "" << CC

& "&