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.
Just looking at that data I would be willing to bet the data in the Inventory table isn't unique based on the item number as you could have multiple received dates and location dates.
Go to the Table view though, as long as you have the July 2018 or later update. (Or maybe June 2018...)
Click on the inventory table, then the item table. Look at the very last row. Is your row count and distinct values count identical for the item? If not, you have dupes.
if they are, check your data types. They look like both are text given alignment, but I'd still verify.
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.
