Power BI On-demand Loading Capabilities for Large Models
If you have a small amount of data to use for your Power BI, queries are populated in a matter of seconds. But for organizations with large datasets, Microsoft has added on-demand load capabilities to speed things up for you and your employees.
Last month, Microsoft announced on-demand load capabilities to further ensure highly performative and reliable large datasets. With on-demand load, large dataset mode enabled models are hydrated into memory faster, which can provide significantly improved report performance.
Due to user inactivity, datasets can be evicted from memory. With the new on-demand load capability, relevant data pages are loaded on demand (or paged-in to memory) during subsequent queries or refreshes. Evicted datasets are then made available for queries more quickly and reliably.
Based on sample datasets Microsoft used for internal benchmarking, it found on-demand load can significantly improve the downstream user experience, observing up to a 38 percent reduction in report load times.
This new functionality is most significant with larger models – for small datasets, load times typically aren’t a problem. However, with large models exceeding 5 gigabytes, the large data volumes can begin to affect performance. With on-demand load in Power BI Premium, the query performance of your largest data sets, even when previously evicted due to user inactivity, can be blazing fast.
On-demand loading also surfaces additional information that can be used to understand the state of your models.
You made the right choice by implementing an ERP system, so make sure you’re taking the steps necessary to achieve your desired ROI on the system. 2W Tech is a Microsoft Gold Partner and would love to introduce your business to Power BI and the benefits this data analytics product can bring to your business. Contact 2W Tech today to see how robust dashboards can be customized to your business intelligence needs.