topic Re: Merge to Tables in Developer https://community.fabric.microsoft.com/t5/Developer/Merge-to-Tables/m-p/316279#M9359 <BLOCKQUOTE><HR /><a href="https://community.fabric.microsoft.com/t5/user/viewprofilepage/user-id/48609">@Dimadon</a> wrote:<BR /> <P><SPAN>Hi, I need a way to connect two tables. The unique value exists, an order number is used as the identifier. But this number exists several times, so Power BI does not allow it. Can Someone help me here?</SPAN></P> <P>&nbsp;</P> <P><SPAN>Thanks a lot!</SPAN></P> <HR /></BLOCKQUOTE> <P><a href="https://community.fabric.microsoft.com/t5/user/viewprofilepage/user-id/48609">@Dimadon</a></P> <P>While the order number exists several times, how can it be unique? For more clarification, could you post any dummy data of those two tables?</P> Mon, 04 Dec 2017 06:03:55 GMT Eric_Zhang 2017-12-04T06:03:55Z Merge to Tables https://community.fabric.microsoft.com/t5/Developer/Merge-to-Tables/m-p/315989#M9348 <P><SPAN>Hi, I need a way to connect two tables. The unique value exists, an order number is used as the identifier. But this number exists several times, so Power BI does not allow it. Can Someone help me here?</SPAN></P><P>&nbsp;</P><P><SPAN>Thanks a lot!</SPAN></P> Sat, 02 Dec 2017 15:37:04 GMT https://community.fabric.microsoft.com/t5/Developer/Merge-to-Tables/m-p/315989#M9348 Dimadon 2017-12-02T15:37:04Z Re: Merge to Tables https://community.fabric.microsoft.com/t5/Developer/Merge-to-Tables/m-p/316279#M9359 <BLOCKQUOTE><HR /><a href="https://community.fabric.microsoft.com/t5/user/viewprofilepage/user-id/48609">@Dimadon</a> wrote:<BR /> <P><SPAN>Hi, I need a way to connect two tables. The unique value exists, an order number is used as the identifier. But this number exists several times, so Power BI does not allow it. Can Someone help me here?</SPAN></P> <P>&nbsp;</P> <P><SPAN>Thanks a lot!</SPAN></P> <HR /></BLOCKQUOTE> <P><a href="https://community.fabric.microsoft.com/t5/user/viewprofilepage/user-id/48609">@Dimadon</a></P> <P>While the order number exists several times, how can it be unique? For more clarification, could you post any dummy data of those two tables?</P> Mon, 04 Dec 2017 06:03:55 GMT https://community.fabric.microsoft.com/t5/Developer/Merge-to-Tables/m-p/316279#M9359 Eric_Zhang 2017-12-04T06:03:55Z