You discover missing data in the source after the dashboard is already live. How do you handle it?

< 1 min read

First, I assess the extent of the missing data and identify which metrics or reports are affected.
I validate whether the issue is from the source system, ETL process, or data refresh failure.
I immediately inform stakeholders about the issue and explain the potential impact on dashboard numbers.
If possible, I temporarily add a note or alert in the dashboard indicating data is incomplete.
In one project, we paused daily reporting until the missing data was backfilled.
I coordinate with the data engineering or source system team to correct and reload the data.
After the fix, I revalidate the numbers to ensure accuracy before confirming to stakeholders.
Finally, I suggest adding data quality checks to prevent the issue in future refresh cycles.

Power BI Essentials