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
Phyxius
Regular Visitor

Linking to a single name table from 4 different tables

Hi.

 

I have data in four different spreadsheets which represents the Accounts Payable Transaction History of 4 separate financial systems. In each financial system, the business refers to exactly the same vendor but often with a different name. I need to map all names for the same entity from these four separate records to a single name, within a separate table which I can then use in a PowerBi query.

I'm a new user, self teaching and learning as I go. I have been advised that Merge, Append and the creation of a "Link Table" with a unique key (value/identifier) are essential but do not know where to start.  Can the community please help? Thanks in advance.

 

Data source.PNG

1 ACCEPTED SOLUTION

Hi Yuliana, thanks for the post.

 

Correct, I was hoping to somehow create a link table in PowerBI and then use that within a larger spend analysis query. The spend data attached to each table record of a vendor would then carry through to the vendor record in the link table, irrespective as to the financial system from which it originated.

 

The only relationship between names is text. I am unable to obtain a DUNS, Tax or company record number for the entities to act as a unique key.

 

 

View solution in original post

2 REPLIES 2
v-yulgu-msft
Microsoft Employee
Microsoft Employee

Hi @Phyxius,

 

The "Vendor Link Table" is your desired result which should be generated in Power BI right? Is there any relationship about vendor names in these 4 tables? Apart from these 4 financial tables, is there any other source that can determine the mapping relationship of vendor names? If all these tables are completely separate, there is no way to achieve above requirement in Power BI. You have to generate the Link table in your source data to list all mapping relationships.

 

Regards,

Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hi Yuliana, thanks for the post.

 

Correct, I was hoping to somehow create a link table in PowerBI and then use that within a larger spend analysis query. The spend data attached to each table record of a vendor would then carry through to the vendor record in the link table, irrespective as to the financial system from which it originated.

 

The only relationship between names is text. I am unable to obtain a DUNS, Tax or company record number for the entities to act as a unique key.

 

 

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.