We are currently running Power BI Embedded at the A1 tier in Azure which is allocated 3GB cache. We have a few datasets in direct query mode that are set to refresh the cache every 15 mins. We also have a few datasets using imported mode and are set to refresh the data every hour. Today we started to receive an error message when our imported datasets were trying to refresh. "You have reached the maximum allowable memory allocation for your tier. Consider upgrading to a tier with more available memory."
I am a little confused on what exactly uses the cache and what is being stored in the cache.
When refreshing and imported dataset, does the data get put into cache during the refresh and then moved out once it
completes?
When refreshing the cache for a dataset in direct query mode, is it holding the entire dataset in cache? Or does it only cache the data it needs for the dashboards and tiles in use?
Is it possible to turn off the scheduled cache refresh for a dataset in direct query mode.?
Is there any good documentation or articles about what utilizes the cache in the PBI Service?
Is it possible to monitor the capacity so that we can try and prevent this?
