Forum Discussion

Ktrain's avatar
Ktrain
Frequent Visitor
8 years ago
Solved

Can not link table

Hi Everyone,   I am trying to link the Column Skus in the Order Line table to Item ID in the Inventory Details Table. Both of them have the unique values. The one in the Inventory Details Table hav...
Need Help
Tutorial Requests
  • edhans's avatar
    edhans
    8 years ago

    You need an inventory master table, one that is just the items and their other dimensions, like item name, height, width, etc. It looks to me like that is an inventory transaction table that has dates items were made, where they are stored in a warehouse, etc. That would be a many to many relationship and Power BI cannot handle that. Even the new many-to-many possibility in the new composite models, released last week, I'm not sure yet how that has been implemented.

edhans's avatar
edhans
Community Champion
8 years ago

You need an inventory master table, one that is just the items and their other dimensions, like item name, height, width, etc. It looks to me like that is an inventory transaction table that has dates items were made, where they are stored in a warehouse, etc. That would be a many to many relationship and Power BI cannot handle that. Even the new many-to-many possibility in the new composite models, released last week, I'm not sure yet how that has been implemented.

Ktrain's avatar
Ktrain
Frequent Visitor
8 years ago

edhans. I will make the master skus list, and go from there. Thank you for you help and fast repsond.