Forum Discussion
Using LookUpValue
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
Super UserHi 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
Yes, 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!