Forum Discussion
Email alert or notification based on missing data
Hi powerbiexpert22 Yes, it is possible; you could try this with Power Automate. Create a measure in Power BI to identify missing data, such as null counts or expected data gaps. Publish the report and set up a data-driven alert for the missing data condition. Use Power Automate to trigger an email notification whenever the alert is activated.
If this post helped please do give a kudos and accept this as a solution
Thanks In Advance
Hello powerbiexpert22 ,
Thank you for reaching out to the Microsoft Fabric Community Forum.
I’d also like to thank Akash_Varuna for their excellent suggestion to use a DAX measure with Power BI data alerts and Power Automate to address your need for email notifications based on missing data.
For detailed guidance, refer to these official Microsoft resources:
- Create data alerts in Power BI: Step-by-step guide to setting up data-driven alerts in Power BI.
- (Optional) Power BI integration with Power Automate: For broader integration options between Power BI and Power Automate, such as refreshing datasets or exporting data.
- Introduction to Data Activator in Microsoft Fabric: If you’re using a Fabric-enabled workspace, explore Data Activator (preview) for an alternative alerting approach.
If this information is helpful, please “Accept as solution” and give a "kudos" to assist other community members in resolving similar issues more efficiently.
Thank you.