Forum Discussion
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 scenario we should go with dual mode?
I have gone through below documentation however it does not explain me clearly the need of dual mode in Power BI
Customer Dim (Import)
Product Dim (Import)
Date Dim (Import)
Sales Fact (Direct Query)
Hi powerbiexpert22 ,
Please read the following articles:
Composite Model in Power BI; DirectQuery and Import Data Combined - RADACAD
Best Regards
2 Replies
Hi powerbiexpert22 ,
Please read the following articles:
Composite Model in Power BI; DirectQuery and Import Data Combined - RADACAD
Best Regards
As per my understanding on your problem. I would like to suggest few points as mentioned below
- Customer Dim (Import)
- Product Dim (Import)
- Date Dim (Dual)
- 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.
