Create bridge table from dataset connected via DirectQuery

[Anonymous]

Greetings. 

I have connected to two datasets via DirectQuery and I need to create a relation between them. 

Both datasets have a Supplier ID column without distinct values. 

How do I create a new table with distinct Supplier IDs from one of the datasets and use that as a bridging table?

Thank you in advance. 

[amitchandak · Accepted solution]

@Anonymous , Have you tried creating a table in import mode like below and use that to join two table and analyze

 Supplier Dim= Union(DISTINCT('Data 2'[ Supplier ID]), DISTINCT('Data 1'[ Supplier ID]))

[Anonymous]

That worked brilliantly and thank you so much! 😄

I wasn't even aware that was possible...