Forum Discussion
LCFC
1 year agoNew Member
Stop empty report from being sent
I have a daily invoiced report that is sent to a specific broker. Some days, a specific broker may not have any orders that are invoiced. This would also apply to weekends when nothing gets invoiced....
- 1 year ago
Hi LCFC
If you’re sending reports using Power BI subscriptions, there’s no built-in way to stop emails when there’s no data.In that case, you’d need to use a tool like Power Automate to check for invoiced orders first and only trigger the email if there’s data to send.
Did it work? 👍 A kudos would be appreciated
🟨 Mark it as a solution to help spread knowledge 💡
DataVitalizer
1 year agoSuper User
Hi LCFC
If you’re sending reports using Power BI subscriptions, there’s no built-in way to stop emails when there’s no data.
In that case, you’d need to use a tool like Power Automate to check for invoiced orders first and only trigger the email if there’s data to send.
Did it work? 👍 A kudos would be appreciated
🟨 Mark it as a solution to help spread knowledge 💡