Forum Discussion

powerbiexpert22's avatar
powerbiexpert22
Icon for Impactful Individual rankImpactful Individual
1 year ago
Solved

Composite model vs Dual storage mode

I am not sure when I should use dual storage mode in Power BI. example I have below mentioned tables, I can define customer, date and product in import mode and Sales in direct query mode , in which ...
Need Help
suparnababu8's avatar
suparnababu8
Icon for Super User rankSuper User
1 year ago

Hi powerbiexpert22 

 

As per my understanding on your problem. I would like to suggest few points as mentioned below

 

  1. Customer Dim (Import)
  2. Product Dim (Import)
  3. Date Dim (Dual)
  4. Sales Fact (Direct Query)

Why am telling you keep Date Dim in Dula mode.

  • When you set a table to Dual storage mode, it can function as either DirectQuery or Import, depending on its relationship with other tables.
  • So, if you set the storage mode of the Dim Date table to Dual, you might receive a warning that this process could take some time. This is because changing the storage mode to Dual creates a copy of the table in memory.
  • This in-memory copy acts like an Import table, while another version of the table operates through DirectQuery. 

I hope you are clear now. Thanks.