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.
Thank you very much. To clarify, using a live connection to SSAS there's no way to access cached data, correct? I'm trying to understand if there's some way of using SSAS live connection without querying the SSAS database every time a user views a report.
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.