PBI Auto-Refreshes Even With Error in Source Data & Refresh Failure Notification not Being Sent

Hi Nonso 

You're facing two key issues with Power BI Online auto-refresh: first, the refresh completes even when there are errors in the source data, and second, failure notification emails have stopped. Normally, Power BI refreshes should fail if there are critical errors, but if the issue lies within the data (such as missing or incorrect values), the refresh may still succeed because Power BI does not automatically validate data integrity. To prevent this, you can implement error handling in Power Query, use validation tables, or introduce conditional checks that force a failure when critical data is missing. Regarding the missing email notifications, possible causes include email filtering, admin setting changes, or your user role no longer being recognized. You can troubleshoot by manually triggering a failure, checking your dataset ownership in the workspace, and reviewing Power BI Admin Portal settings. As a workaround, using Power Automate to send custom failure alerts ensures you stay informed when issues occur. These steps should help restore proper error detection and notification in your Power BI environment.