To send each manager their own Power BI report, you burst the report on a column such as Region: the report is filtered once per value and each filtered copy is emailed to the person responsible for that value. Native Power BI subscriptions can do per-recipient delivery in some capacity scenarios, and recipients generally need access to the report. KPImailer for Power BI does it on Pro or Premium, and recipients need no Power BI licence.
What you need
- A Power BI report with a column that identifies the owner of each slice, such as
RegionorStore. - Ideally, a column with the owner’s email address, for example in a
Region managerstable related to your facts. - KPImailer for Power BI, connected through a Microsoft Entra app registration (service principal or delegated sign-in).
Step by step
- Create the report in KPImailer and choose the Power BI report as the source.
- Design the email. Drag the visuals you want onto the canvas and write a short text. Use a measure token so the headline number is part of the sentence.
- Open Bursting and pick the cycle column, for example
Region. Use Count values to see how many copies a run will send before you switch it on. Date columns are not allowed as cycle fields. - Pick a recipient column if your model has one. Each address then receives only the value it relates to: the West manager gets West. Leave it empty to send every copy to the report’s own recipients.
- Personalise the wording with the
{{burst.value}}token, for example a subject ofWeekly sales · {{burst.value}}and an attachment namedSales_{{burst.value}}.xlsx. - Attach files: Excel with up to 20 sheets or one formatted table, CSV, PDF of the report or one page, or PowerPoint.
- Preview and schedule. Choose the time zone and a cron schedule. The schedule activates once the report and connection validate.
Tips
- Watch hand-typed recipients. Anyone added directly to the report’s recipients receives every copy. A director copied on a twelve-region burst receives twelve emails.
- Gate with a condition. A DAX condition can stop a run when there is nothing to report.
- Alert on refresh failure. Add a dataset refresh alert so you know before the reports go out with old data.
Ready to try it? Start a free trial or read more about KPImailer for Power BI.