SSAS-Hybrid mode.

Hi Kakikupart 

I would like to sincerely apologize for the solution provided in my earlier below given response. I realized that my reply was not accurate.


Here is the information  as follows:

1.Understanding Import Mode and Direct Query Mode

• Import Mode: When Direct Query Mode is turned off, the table operates in Import Mode. This means the data is loaded into memory and queried from there.
• Direct Query Mode: When Direct Query Mode is turned on, the table queries data directly from the source.

2.Steps to Configure the Tables:

• INVENTORY Table (Import Mode):
1. Select the INVENTORY table in the Model view.
2. In the Properties pane, set the Direct Query Mode property to Off.
3. This will configure the table to use Import Mode .
• SALES Table (Direct Query Mode):
1. Select the SALES table in the Model view.
2. In the Properties pane, set the Direct Query Mode property to On.
3. This will configure the table to use Direct Query Mode (data is queried directly from the source).

3.   Save the changes and process the model to reflect the updated configurations.

4.Test in Power BI after deploying, connect to the model and run queries to ensure:

      INVENTORY table uses in-memory(Import) data and SALES table fetches data directly from the source.

If you have any further questions or need additional help with this, feel free to reach out     to us for further assistance!

If you find this post helpful, please mark it as an "Accept as Solution" and give a KUDOS.