When using composite models in Power BI, you have a choice for how to store your tables. Storage mode gives you options, but why would I pick one versus the other for my dimension tables? Adam has you covered!
Use composite models in Power BI Desktop
DirectQuery model guidance in Power BI Desktop