Forum Discussion
Share your thoughts on DirectQuery for Power BI datasets and Azure Analysis Services (preview)
This is a great feature, when using/testing it I run into the following problem though.
- I connect to an Azure Analysis Services tabular model
- Then I add a calculated column to a fact table using RELATED to add a value from a dimension table within the same model which has a one to many relationship with the fact table, no errors appear when doing this
- As soon as I try to use the calculated column (or something using it) in a visual this error appears:
- The strange thing is that this does work when doing the same thing but with a different dimension from the model (no error appears when using it)
What can cause this error? As far as I can tell I'm not doing something that isn't supported and as I'm referring to a table within the same model I don't see any issues (no limited relationship).
One thing that is different between the dimension for which this works and the one for which it doesn't: the key in the fact table which relates to the dimension which doesn't work has blank values as the dimension isn't applicable for all the rows. In this case I expect RELATED to return a blank value. Also I'm pretty sure this worked when I tested it earlier in the year.
Hopefully you can help me with this, thanks in advance!
- jeroenterheerdt5 years ago
Microsoft Employee
hmm, interesting, let me talk to the engineers. Thanks for reporting!
- jeroenterheerdt5 years ago
Microsoft Employee
we were unable to reproduce this - can you please open an issue for this so we can collect some more info?
- m_b5 years agoRegular Visitor
Sure, do you mean I should post it on Issues - Microsoft Power BI Community or should I open a support ticket?
- jeroenterheerdt5 years ago
Microsoft Employee
either works - but support ticket is faster.