Forum Discussion
Microsoft EmployeeShare your thoughts on DirectQuery for Power BI datasets and Azure Analysis Services (preview)
Microsoft Employee1. Can you give more info on the data sources you are connected to for Product and Product 2?
2. I don't believe so, but perhaps jeroenterheerdt can help answer your question about performance.
3. This is an interesting idea. We don't allowe for that right now, but can you describe a bit more about your expected behavior?
4. When this feature is GA it will be available for both shared and premium.
Thanks!
Advocate III have the same question as Mariusz, and I think it gets at architectural issues that Power BI has with conformed dimensions. It's never been clear to me the best way to handle them as there is no concept of shared dimensions like there used to be in SSAS MD.
If there's two models, both with a copy of the same Product dimension and those two models are "composited" together, you're going to have two Product dimensions. How do you get the two models to work together across this dimension? Can you remove one? Can you link them together somehow? It seems to me that each model may contain its own measures with references to its own Product dimension. How do we keep these working?
Well, is this realy related to "Composite"? Same question with "Import"...
The usual way is to have just one dim with several relations and to build measures with "USERALTIONSHIP".- nicg
Hi Oliver,
I'm not sure I follow you. I'm talking about multiple models, not multiple tables within a single model.
Model A has a star schema that includes Product dimension.
Model B has a star schema that includes Product dimension.Model C is a composite of A and B. C now contains Product(A) and Product(B). What's the right way of handling this situation?
- jeroenterheerdt
conforming dimensions is something we are still working on.
