Forum Discussion
Persistent Cache in Power BI Service
- 4 years ago
Yes, a persistent cache is used when refreshing queries in the PBI Service. However, the Service caching is slightly different than what happens when refreshing in Desktop. The primary difference is that in Desktop refresh, a single cache is shared by all the queries being refreshed. But in Service refresh, each query gets its own persistent cache. This can lead to Service refresh being slower than Desktop refresh, if the queries benefit from using the results cached by other queries in the dataset.
Thanks, lbendlin! Actually, I'm referring to the external query caching that Power Query can do when loading data before it is in the dataset (so is different from whether or not the dataset is currently in memory).
I don't think that's a thing, unless I misunderstand what you're trying to figure out.