Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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!
@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
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
85 | |
83 | |
66 | |
61 | |
59 |
User | Count |
---|---|
194 | |
111 | |
105 | |
79 | |
71 |