cancel
Showing results for 
Search instead for 
Did you mean: 
Reply

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.

1 ACCEPTED SOLUTION
d_gosbell
Super User
Super User


@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

2 REPLIES 2
d_gosbell
Super User
Super User


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

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. 

Screenshot_1.png

Helpful resources

Announcements
Carousel_PBI_Wave1

2023 Release Wave 1 Plans

Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.

Power BI Summit Carousel 2

Global Power BI Training

Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!

Thank you 2022 Review

2022 Monthly Feature Releases

We had a great 2022 with a ton of feature releases to help you drive a data culture.