Reports built on very large datasets were slow to refresh and placed heavy strain on the source database.
Enterprise-scale data, without the wait
Client details are confidential, so this engagement is described by the challenge and the outcome.
We implemented incremental refresh and tuned complex DAX using DAX Studio and Performance Analyzer.
Faster refreshes, quicker report loads and far less pressure on source systems.
Why large datasets slow reports down
When every refresh reloads the full history, refresh times grow with the data and the source database carries the load. Meanwhile, inefficient measures and heavy models make every click in the report slower than it needs to be.
What we changed
Incremental refresh meant that only recent data was reloaded on each refresh, which shortened refresh times and eased the load on the source. We profiled the report with Performance Analyzer and DAX Studio, found the slowest measures and queries, and rewrote them to do less work.
What it means for a business like yours
Performance problems are rarely fixed by simply buying more capacity. Addressing the model, the queries and the measures usually produces larger and longer-lasting gains, and keeps the report responsive as your data continues to grow.
Related services
Let's build what's next.
Not sure where to start? Ask for a free dashboard review. We'll get back to you as soon as we can.
Our working hours overlap with the US, Europe and Asia-Pacific.