Events
Power BI DataViz World Championships
14 Feb, 4 pm - 31 Mar, 4 pm
With 4 chances to enter, you could win a conference package and make it to the LIVE Grand Finale in Las Vegas
Learn moreThis browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
APPLIES TO:
Power BI Desktop
Power BI service
Dynamic per-recipient subscriptions are designed to simplify distributing a personalized copy of a report to each recipient of an email subscription. You define which view of the report an individual receives by specifying which parameters are applied to their version of the report.
Dynamic per-recipient subscriptions are available for paginated reports and for Power BI reports. This article is about paginated reports. To learn about dynamic subscriptions for Power BI reports, see Dynamic per recipient subscriptions for Power BI reports.
The dynamic subscription parameters are stored in a separate Power BI semantic model. The semantic model defines the mapping between recipients and respective parameters. When it’s time to send out the report, the latest data available in your semantic model determines who receives a subscription and with what parameter applied.
Do you want to create one subscription that sends customized views of a report to your subscribers based on parameters that you set? Perhaps you're a training director and want to send a report to various managers, each interested in the completion progress of their employees. Now you can create a subscription and customize the report so that each manager only sees data related to their own employees. To do this, Power BI connects to a semantic model that defines the mapping between recipients and parameters. When it's time to send out the report, the latest data available in this semantic model determines which manager receives a report in their inbox, and what parameters are applied to that report.
For users familiar with SQL Server Reporting Services (SSRS), this feature is similar to data-driven subscriptions.
Start with a paginated report that has parameters. You know that the report has parameters if you select Parameters and see dropdown options in the header. This report has a parameter for Manager name and a parameter for Employee.
Select Subscribe to report.
The Subscriptions window opens and there are no subscriptions yet. Select Create a subscription.
Select Dynamic per recipient.
Highlight the Power BI semantic model that contains your recipient data. Recipient data includes columns for email address, parameters that can be varied per recipient, and optionally, attachment type and email subject.
In some organizations, there might be a corporate employee Power BI semantic model that fits the purpose. Or, you might need to create a new semantic model that contains email addresses, and values for report parameters. The critical piece of data is the email addresses. In order for you to set the parameters on a per-recipient basis, the semantic model needs to include the email addresses of all potential recipients. Select Next. In this example, our parameter mapping semantic model is named Training data.
The Select and filter data window lists the fields that can be set dynamically. In this example, we have a field for email address and we have several parameters. Select the columns from your semantic model that you want to be varied for each recipient. Email address and parameters can be set dynamically based on data in the Power BI semantic model.
The Select and filter data window displays the list of fields from the Training data semantic model that can be used to dynamically filter your Manager training report subscription. In this example, we have Email address, Email subject, Report parameters, and Attachment file type. These fields from the Training data semantic model can be tied to the subscription.
Select the relevant fields that you'd like to be varied per recipient. Here we have Email and two fields for parameters: Employee name and Manager name. Optionally, add filters and change the method of aggregation by expanding the Filter and Build panes. As you add data, Power BI builds a table. In this window, narrow down who should receive the report. For our example, we select only those employees who are also managers.
Select Next when you're satisfied with your selections.
In the Email details window, name the subscription, add recipients separated by commas or semicolons, and a subject, and select the type of attachment to use. Many of these fields offer the option to use the dynamic parameters. In this example, Recipients are dynamically added from the Training data semantic model, using the Email field. And, the email Subject is dynamically set using the Manager name parameter. The link icon lets you know that dynamic content is being used.
Name your subscription.
Manually enter recipient email addresses, or use the dropdown to select a value that dynamically selects recipients from the Training data semantic model.
Manually add an email subject, or use the dropdown to dynamically create individualized subjects using the Manager name field from the Training data semantic model.
Add optional details. Type a message to recipients. Use the toggles to add a link to the report in Power BI and to include a preview image of the report in the email. The preview image is the first page of the report. The preview image shows the report with the recipient's unique parameters applied.
Select the Attach full report dropdown to display the list of options. Select a format. Sensitivity labels are applied to the email attachment and the attachment respects all privacy labels for the report. The size of the attachment is limited to less than 25 MB.
Choose Next.
The Parameters window displays all of your report parameters, and you choose which to set dynamically based on a column in the Power BI semantic model. Paginated reports allow you to specify the view of the report people receive in the subscription by setting the parameters in the Parameters window. For each parameter, decide whether to use the current value, default value, or dynamic value. For our scenario, sending training completion reports to managers, it makes sense to use the Manager name dynamic parameter and the Employee name dynamic parameter. But there are other scenarios where you might want to use a mix of static and dynamic parameters. For example, if your report had continent and country-region data, you might want to set the continent as South America and use dynamic parameters for the country-regions.
In the Set the schedule window, create a schedule for your dynamic subscription.
Select a Start date and optionally, an End date for your subscription. By default, the start date is the date you created the subscription and the end date is one year later. You can change it to any date in the future at any time before the subscription ends. When a subscription reaches an end date, it stops until you re-enable it. You receive notifications before the scheduled end date to ask if you'd like to extend it.
Use the Repeat dropdown to select a frequency for your subscription. You might choose daily, weekly, or monthly. You also can adjust your time zone.
Tip
To receive a subscription email only on certain days, select Weekly and then select the week day checkboxes. If you select Monthly, enter the day(s) of the month you wish to receive the subscription email.
Choose a Scheduled Time for the subscription. You can have it run on the hour, or at 15, 30, or 45 minutes past for a specified time zone.
By turning off Active subscription, you have the option of triggering this subscription manually instead of having it run on a recurring basis.
In the Review and finish window, select a heading to review your settings. If all the settings look correct, select Save and close. If any need changes, select the pencil icon to make edits.
Your Subscriptions pane lists the new subscriptions. The link icon lets you know that dynamic content is being used.
Another way to review your subscription is to select the arrow in the Subscriptions pane.
As with other subscriptions, you can edit, delete, turn on, and turn off the subscription.
Events
Power BI DataViz World Championships
14 Feb, 4 pm - 31 Mar, 4 pm
With 4 chances to enter, you could win a conference package and make it to the LIVE Grand Finale in Las Vegas
Learn moreTraining
Learning path
Manage workspaces and semantic models in Power BI - Training
In this Learning Path, you'll learn how to publish Power BI reports to the Power BI service. You'll also learn how to create workspaces, manage related items, and data refreshes for up-to-date reports. Additionally, implement row-level security to restrict user access to relevant data without the need for multiple reports.
Certification
Microsoft Certified: Power BI Data Analyst Associate - Certifications
Demonstrate methods and best practices that align with business and technical requirements for modeling, visualizing, and analyzing data with Microsoft Power BI.