Keldon Fischer

← Work  /  Project 04

Silent refresh recovery

A customer-facing dashboard had quietly failed to refresh for a month. Traced it to a dataset hitting its 48GB memory ceiling and reduced the footprint to restore daily refresh.

Role
Diagnosis and remediation
Timeframe
BI platform capacity
Result
30+ days outage resolved
  • Power BI Premium
  • SQL
  • Capacity metrics

The problem

A customer-facing dashboard had not refreshed in more than 30 days and nobody had noticed. It kept serving data without complaint, so every decision made from it during that month was quietly based on stale numbers.

Silent failures are the most dangerous kind. A broken dashboard announces itself; a stale one does not.

What I did

I traced the failure to a dataset that had grown into its roughly 48GB memory ceiling on the capacity. Refreshes were being evicted rather than erroring loudly, which is why no alert ever fired.

I reduced the dataset footprint enough to bring it back under the ceiling and restore daily refresh, then looked at what else on the capacity was heading the same way.

The outcome

Daily refresh was restored and the dashboard returned to being trustworthy.

The broader lesson was about monitoring. Capacity limits fail quietly by design, so freshness needs to be surfaced on the dashboard itself rather than trusted to the platform.