New governance setting for cache refreshes from Azure Analysis Services
Published date: 25 April, 2019
Data visualisation and consumption tools over Azure Analysis Services sometimes store data caches to enhance report interactivity for users. The Power BI service, for example, caches dashboard tile data and report data for initial load for Live Connect reports.
Enterprise BI deployments where semantic models are re-used throughout organisations can result in a great deal of dashboards and reports sourcing data from a single Analysis Services model. This can cause an excessive number of cache queries being submitted to Analysis Services. In extreme cases, it can overload the server.
This is especially relevant to Azure Analysis Services (as opposed to on-premises SQL Server Analysis Services). Models are often co-located in the same region as the Power BI capacity for faster query response times, so they might not even benefit much from caching.
The new ClientCacheRefreshPolicy property allows IT or the Analysis Services practitioner to override this behaviour at the Azure Analysis Services server level, and disable automatic cache refreshes. All Power BI Live Connect reports and dashboards will observe the setting irrespective of the dataset-level settings, or which Power BI workspace they reside on. For more information on how to make use of this property, see the Analysis Services server properties page.