Forum Discussion
When Does Cache Refresh Happen w SSAS?
Hi all. I found an article that describes direct connections(SSAS for example). I had a question on some things. https://docs.microsoft.com/en-us/power-bi/refresh-data#live-connections-and-directquery...
No problem. No with a live connection the report will always go to the SSAS database. Of course you could set your models to run in memory in the SSAS server and they will be quick to respond.
Hope this helps.
There's two modes, direct query and cached, depending on how you authored the report.
Direct query, queries your back end data source with every query or interaction with the report (e.g. every click). Cached, uses a copy of the data stored locally and is refreshed by the refresh plan you setup on the server.
- Does “every click” include loading a dashboard?