Forum Discussion
Relationship between dimension fields
prateeks，
I make a test with a table visual. It is possible to create a table visual using the dimension fields you mention. It is impossible to drag them to Values section of other charts in Live mode.
Regards，
Lydia
prateeks,
What error message do you get in Power BI Desktop? What mode do you choose to import data from SSAS cube to Power BI Desktop, import or connect live?
Do you establish 1:many relationship between DIM_CURR and FACT_TRANS table , and establish 1:many relationship between DIM_CUSY and FACT_TRANS table? If so, make sure the filter direction is set to Bi directional.
Regards,
Lydia
Hi Lydia,
- There is no error message, only PBI only doesn't allow to drop the field into "Values".
- I am using connect live.
- Yes the relationship between DIM & FACT is 1:many
- I am using SSAS Multidimensional model, so cannot set the bi-directional filters.
Do I need to use tabular mode?
prateeks,
I am unable to reproduce this issue when connecting to SSAS Multidimensional model with Connect Live mode. I suspect the issue is related to the relationship you create between dimension and fact tables. Please check the relationship in SSAS side.
Regards,
LydiaHi Lydia,
Its very straight forward relationship between DIM & FACT.
DIM is directly linked to FACT. Please see below details -
prateeks，
I make a test with a table visual. It is possible to create a table visual using the dimension fields you mention. It is impossible to drag them to Values section of other charts in Live mode.
Regards，
Lydia