Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
MaryMir
New Member

Data connection issue

Hi all,

 

 I have 2 tables and need to make a connection between them . Coulmn 'Account' should be same in both tables ( both 'Account' columns have duplicate values with different IDs) . I am trying to merge both 'Account ' columns from each table to a new table to uase as bridge table but the merge shows there are number of non matched values, is this because of duplicate values??

 

thanks 

4 REPLIES 4
Kishore_KVN
Super User
Super User

Hello @MaryMir ,

In a way yes and it also depends on the type of join that you are trying to make either left or right or inner etc

Instead of creating a bridge table like that take a dimension table of Account if available. 

If not duplicate one table either one or two depends on number of records and delete all other columns except Account column and delete duplicates in the Account column. This table you can use as bridge table. 

 

If this post helps, then please consider accepting it as the solution to help other members find it more quickly. Thank You!!

Thanks @Kishore_KVN  by deleting the duplicate values , doesn't it affect the data accuracy? For examle I have 120 records with same Account name but different contract name. Each of thoes 120 records are not same Account that has been used for different contracts, each are specifically a row of values. 

No it will not miss any information as its going to be just a bridge table it will just help to connect two other tables thats it. 

Unfortunately didn't work, it gives me Many to Many relationship

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.