Keeping reports current and fast.
WHAT REFRESH DOES
Reloads data from the source into the model.
WHAT DETERMINES FREQUENCY
The licence tier, and the source's ability to support it.
WHAT A GATEWAY IS
A component allowing the cloud service to reach data sources on your network.
WHAT IT REQUIRES
A machine that is always available, and maintained.
WHAT TO MONITOR
Refresh failures, which otherwise go unnoticed until someone reads stale data.
WHAT TO ALERT ON
Failed refreshes.
WHAT CAUSES SLOW REPORTS
Large models Complex calculations evaluated per row Poor relationships Too many visuals on one page Queries returning more than needed
WHAT TO DO
Reduce the model: fewer columns, fewer rows, appropriate types
Move transformation to the source Simplify calculations Reduce visuals per page
WHAT INCREMENTAL REFRESH PROVIDES
Refreshing only recent data rather than everything.
WHY THAT MATTERS
It makes large datasets practical.
WHAT TO MEASURE
Refresh duration, and report load time.
WHAT TO REVIEW
Datasets nobody uses, which still consume refresh capacity.
