Power BI - Condition based Report Subscription

[PBI_V2]

Hello All,

We need to setup report subscription in such a way that it should send report to different region groups with their respective region data from a Dashboard. We have a region slicer which filters the data for the region.

Below is the example:

Separate email should go to each region whith thier region data only on daily basis.

Americas Region Group should get an email with report attachment which contains only Americas region data
APAC Region Group should get an email with report attachment which contains only APAC region data

MEA Region Group should get an email with report attachment which contains only MEA region data

Europe Region Group should get an email with report attachment which contains only Europe region data.

How to achieve this requirement.

Thanks,

PBI V2

[Jonvoge · Accepted solution]

Hi PBI_V2

I find that the easiest way to accomplish this is by using Power Automate: Export and email a report with Power Automate - Power BI | Microsoft Learn

You can also have a look at the Dynamic Subscription feature which is in Preview: Dynamic subscriptions for Power BI reports (Preview) | Microsoft Power BI Blog | Microsoft Power BI

_____________________________________________________
I hope my comment was helpful.
If your question was answered, please mark your post as 'Solved' and consider giving me a 'Thumbs Up'.
Find me on LinkedIn, Sessionize, or my blog Downhill Data

[PBI_V2]

Hello @Jonvoge ,

Thanks for your response. The solution provided by you on dynamic subscription is Amazing! Thank you so much. It fulfilled our requirement.

Thanks,

PBI V2