Forum Discussion
Can not link table
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 : Thank you for your repsond. The item and row count is not the same. The order line table is content all the history order therefore, it has removed skus that is not available in the inventory details table.
What should I so I can link the SKUs column in the Order line table to Item_id in the Inventory Details Table ?
Thank you edhans
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.