Hello,
I have a question about how to relate several BC tables in Power BI.
I need to be able to relate the SalesInvoiceLine table with ItemAttribute, in order to get information from both in one table.
Right now, to relate them, I have done the following:
· SalesInvoiceLine (No) - Item (No). Many-to-one relationship
· Item (No) - ItemAttributeValueMapping (No). One-to-many relationship
· ItemAttributeValueMapping (ItemAttributeValueID) - ItemAttributeValue (ID). Many-to-one relationship
· ItemAttributeValue (AttributeID) - ItemAttribute (ID). Many-to-one relationship
With these relationships, if I try to get a value, for example, the quantity from SalesInvoiceLine and another value from ItemAttribute or ItemAttributeValue, Power BI does not establish the relationship between them.
How should I relate SalesInvoiceLine with ItemAttributeValue and ItemAttribute? Any ideas?
Thank you very much in advance, I’ve been trying for several days and haven’t been able to figure it out!
2
Share
Report
All responses (
Answers (
