Solved: Re: SSAS Live connection - Current Data

giorgi_lommidd · ‎11-19-2019

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.

d_gosbell · ‎11-19-2019

@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?

View solution in original post

RoshnaShrestha · ‎06-26-2024

Hi ,

I use SSAS Live connection Power BI and im not able to set default date . Can you please help me how to set default date.?

Thanks Roshna

d_gosbell · ‎11-19-2019

@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?

giorgi_lommidd · ‎11-25-2019

I am Using import mode. I have backed up SSAS DB to another computer, where SQL DB wasn't transferred and I could connect with "live connection" and with "import" modes of power bi to that SSAS DB model (cube) and could see values. this means SSAS is in Import mode right?

How can I change it to a live mode? The "supported Compatibility level" is 1100.