Connecting Databases/Columns with Different Nomenclatures

[karimk]

Hey everybody.

I want to connect two databases that have different ways of describing my building names.

Example:

Database 1 spells Building 1

Database 2 spells BR - Building 1

What is the best way to do this, without running into the "one of the columns must have unique values"

Thanks!

[v-yuezhe-msft]

@karimk,

Do you get the above error when creating relationship between the two tables in Power BI Desktop? If that is the case, please create a new table containing unique values of the column, then create relationship among the three tables. For more details, please review the following article.

https://blogs.technet.microsoft.com/cansql/2016/12/19/relationships-in-power-bi-fixing-one-of-the-co...


Regards,
Lydia