Subscribe report with conditions

[shareezsaleem]

Hi Experts,

I have built a paginated report and started trigerring emails using Subcribe Report option.

Now, emails are going to the stakeholders on a daily basis.

But I wanted to stop send emails if the table is blank. How can I do that?

[v-tangjie-msft · Accepted solution]

Hi @shareezsaleem ,

To stop sending emails when the table in your paginated report is blank, you can't directly achieve this using the built-in subscription feature. However, you can consider an alternative approach by using Power Automate  to conditionally trigger the email based on the report content.

Here's a high-level outline of the steps you can follow:

1. Create a Power Automate flow.
2. Use the Power BI connector to export your paginated report as a PDF or another format.
3. Add a condition to check if the exported report content is blank or not.
4. If the report content is not blank, use the Send an email action to send the report to the stakeholders.

Please refer to the following document for more information.

 Do not send email if table is empty - Power Platform Community (microsoft.com)

Dynamically Stop Email Subscriptions from send... - Microsoft Fabric Community

[HELP] Don't send emails if the table is empty - Power Platform Community (microsoft.com)

Best Regards,

Neeko Tang

If this post  helps, then please consider Accept it as the solution  to help the other members find it more quickly.