Data Monitoring
A refresh succeeds on one gateway node but fails on another. Compare connector versions, required drivers and network access across cluster members.
Power BI Refresh & Data Reliability2 min read
Read article : Power BI: Gateway cluster node differences
Data Monitoring
A team expects every visual to reflect an immediately committed transaction. Compare the semantic model storage mode, query timing and any report or source caching behavior.
Power BI Refresh & Data Reliability2 min read
Read article : Power BI: DirectQuery freshness assumptions
Data Monitoring
Failed refresh emails reach an unattended mailbox. Trace an actual test failure from model history to the responsible operator and runbook.
Power BI Refresh & Data Reliability2 min read
Read article : Power BI: Refresh failure escalation
Data Monitoring
A restored refresh schedule leaves an unrecognized reporting gap. Compare last accepted business watermark with the current source watermark and expected reporting periods.
Power BI Refresh & Data Reliability2 min read
Read article : Power BI: Recovery after missed refreshes
Data Monitoring
A report page feels slow but only one visual dominates the delay. Capture Performance Analyzer timings for the same filter interaction and separate query duration from rendering overhead.
Power BI Performance & KPI Integrity2 min read
Read article : Power BI: Visual timing breakdown
Data Monitoring
A model grows rapidly after an identifier or free-text column is added. Compare model size and column cardinality before and after the addition and identify actual report usage.
Power BI Performance & KPI Integrity2 min read
Read article : Power BI: High-cardinality model columns
Data Monitoring
A frequently refreshed model stores values that could be computed at query time. Inspect whether the calculation needs row-level storage or only responds to report filter context.
Power BI Performance & KPI Integrity2 min read
Read article : Power BI: Measure versus calculated column
Data Monitoring
A total differs from the sum of the rows displayed in a visual. Evaluate the measure under row and total filter contexts and identify whether it is additive.
Power BI Performance & KPI Integrity2 min read
Read article : Power BI: Filter context in totals
Data Monitoring
Revenue appears twice after combining two fact-like tables. Inspect relationship cardinality and compare distinct business keys at the intended grain.
Power BI Performance & KPI Integrity1 min read
Read article : Power BI: Many-to-many relationship inflation
Data Monitoring
Selecting one category changes an unrelated KPI. Trace relationship filter directions and compare the affected measure with a simpler single-direction model.
Power BI Performance & KPI Integrity2 min read
Read article : Power BI: Bidirectional filter surprises
Data Monitoring
A time-intelligence comparison silently omits the newest period. Compare fact date range with the date table and verify continuous dates where the calculation requires them.
Power BI Performance & KPI Integrity2 min read
Read article : Power BI: Missing date table coverage
Data Monitoring
A conversion KPI changes when the same data is regrouped. Calculate total conversions divided by total visits and compare it with an unweighted average of per-row rates.
Power BI Performance & KPI Integrity2 min read
Read article : Power BI: Ratio of sums versus average of ratios