Skip to content
KPIBot, an AI analyst for your Qlik apps

How to send each manager their own Power BI report

How to burst a Power BI report so every region, store or rep receives only their own data by email, including recipients without a Power BI licence.

By the KPImailer team at Relevance Management · · 6 min read

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 Region or Store.
  • Ideally, a column with the owner’s email address, for example in a Region managers table related to your facts.
  • KPImailer for Power BI, connected through a Microsoft Entra app registration (service principal or delegated sign-in).

Step by step

  1. Create the report in KPImailer and choose the Power BI report as the source.
  2. 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.
  3. 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.
  4. 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.
  5. Personalise the wording with the {{burst.value}} token, for example a subject of Weekly sales · {{burst.value}} and an attachment named Sales_{{burst.value}}.xlsx.
  6. Attach files: Excel with up to 20 sheets or one formatted table, CSV, PDF of the report or one page, or PowerPoint.
  7. 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.

Send your first automated report this week.

Install the 30-day trial, connect your BI platform and design a report. If you get stuck, a product specialist will walk you through it.

No credit card. Every feature included. Nothing is deleted when the trial ends.