SSAS Live connection - Current Data
Hello, I am new to the analysis service and I have question about live connection.
I am using Power BI SSAS Live connection but every time data is updated in the data warehouse, analysis service needs to be processed (deployed) to load the updated date. as far as I know, analysis service is just a data structure and it is not saving information, thus it must always show actual data without the need to refresh, process or deploying.
can someone advise me on how to fix this issue? I want to see live data without SSAS database need to be processed.
giorgi_lommidd wrote:
I am using Power BI SSAS Live connection but every time data is updated in the data warehouse, analysis service needs to be processed (deployed) to load the updated date.
So processing and deployment are technically two separate operations (although the default configuration in Visual Studio does both together). Deployment is the operation that uploads the model strucuture to the server (similar to doing "CREATE TABLE" in SQL). Processing is the operation that loads that structure with data (similar to doing "INSERT" statements in SQL)
as far as I know, analysis service is just a data structure and it is not saving information, thus it must always show actual data without the need to refresh, process or deploying.
SSAS models can be created in 2 different modes. Import mode which does store a copy of the data or Direct Query mode which does not store any data, instead it generates SQL queries against a relational data source.
Are you saying that your model is in direct query mode or are you unsure?
