With email hyperlinks you can facilitate your operational activities.
The link clicked directly from the report will allow user to send an email with just one click.
In Power BI, hyperlinks can be used with buttons, tables as well as our HTML VizCreator custom visuals which will give you a bigger range of options how email links could be used in the report. Download our sample report to see these options in action. It contains many different examples and use-cases. Take a look at the code we use and adjust it to your needs.
It is definitely a useful functionality if you require immediate action from the user. Imagine a case when you review the results and you want to get in touch with someone straight away to give or receive feedback. You can also include email templates to help users execute desired actions more efficiently and cover repetitive tasks.
The Bridger is designed to be used in the Power BI Service on modern browsers. We try our best to also offer most functionalities in the Power BI mobile app on smartphones or tablets but there might be certain restrictions that we can't get around.
How to use it?
We have a free and paid version of the Bridger available for you.
- Free version
In the free version of the Bridger, you are provided with the URL that should be concatenated with the email details.
Clicking the link will trigger the forwarding function, however, the free version will redirect you through a website with a delay of a few seconds from the click to the execution of the requested action.
- Paid version
In the paid version of the Bridger, you are provided with the URL and license key that needs to be added to the link.
Clicking the link will trigger the forwarding function and you will be able to execute the requested action immediately.
How to create the forwarding URL?
You need to construct the URL with several essential components. Note that in order to use spaces in your text, they need to be replaced with %20 using Power Query or DAX. In the email, you will then see spaces instead of %20
This is the main link to the API. It only works when you have added the following parameters to it.
- List of supporting parameters
The actual email content should be included in the URL as well.
|to-email||Yes||List of email addresses of the main recipient(s), these should be comma-separated values e.g., email@example.com|
|cc-emails||No||List of email addresses to put in cc , these should be comma-separated values e.g., firstname.lastname@example.org,email@example.com|
|bcc-emails||No||List of email addresses to put in bcc , these should be comma-separated values e.g., firstname.lastname@example.org,email@example.com|
|Subject||No||Any text that could be used as an email subject e.g., Meeting Notes|
|email-body||No||Any text that could be used as Email Body e.g,
Hi, this is to inform you that tomorrow's meeting has been canceled.
The last element of the URL is the license key. Visit the main Bridger page to request a free or paid license
Once you get your license key you can add &key=[License Key] at the end of the URL
In Power BI we recommend loading your license key as an additional data source (for example from a dataflow) and then adding it to your measures. This will make replacing the license key much easier.
- Free Version
- Paid Version or free trial (including license key)