Forum Discussion
Using LookUpValue
Hi,
I created a calculated column and trying to use the LookUpValue function and am receiving the following error
Underlying Error: DataViewMappingError_ConditionNotHierarchicallyRelated
Activity ID: 77181316-2e02-44ea-b104-201ac8d72366
Also, I am getting an error on my visual saying "You are using fields that don't have a supported set of relationships". Not seeing the issue as I have used this LookUpValue function before.
Hi greenda4,
The error looks more related to the data model/relationships used by the visual.
LOOKUPVALUE can return a value from another table even when there is no physical relationship, but that does not create a relationship between the two tables. If you then place fields from both unrelated tables in the same visual, Power BI can return this message "You are using fields that don't have a supported set of relationships"
Please check the relationships in the data model.
Best Regards,
Maruthi
LinkedIn - http://www.linkedin.com/in/maruthi-siva-prasad/
X - Maruthi Siva Prasad - (@MaruthiSP) / X
3 Replies
- maruthisp
Super User
Hi greenda4,
The error looks more related to the data model/relationships used by the visual.
LOOKUPVALUE can return a value from another table even when there is no physical relationship, but that does not create a relationship between the two tables. If you then place fields from both unrelated tables in the same visual, Power BI can return this message "You are using fields that don't have a supported set of relationships"
Please check the relationships in the data model.
Best Regards,
Maruthi
LinkedIn - http://www.linkedin.com/in/maruthi-siva-prasad/
X - Maruthi Siva Prasad - (@MaruthiSP) / XYes, you are correct! I reviewed the relationships in the model view and was able to correct something. Thanks for your help!
v-abhinavmuCommunity Support
Hi greenda4,
Thank you for the update. Glad to hear that reviewing the relationships in the model helped resolve the issue.
Thank you for sharing the confirmation with the community!
