Forum Discussion
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 have all current skus and the on the the Order Line table have all the history of our order with the skus lines. I tried to link them together in order to do the veovity measure, but I am unsuccessful.
Anyone please can help me, and I am new to PowerBi.
Thank you in advance.
Order Lines and Inventory Details TablesSkus in the Order Lines TableItem ID in the Inventory 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.
4 Replies
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.
