Connect Two Data Sources Together With Primary Key

[ronniesilletti]

Hi Everyone!

I am new to Power BI and have had trouble understanding the following:

I created two excel extracts that have a common key called U_ID. Rather than combine these extracts together using Vlookup in Excel itself before I upload them into Power BI, is there a way to connect these two columns together on PowerBI directly?

If yes, can someone please help me. If not, that sucks and will just need to combine a few files together before the upload. Trying to avoid this so I don't need to do a lot of manual work every single time. 

Connecting directly to the database is not an option. So need a solution to connect two datasets, if possible!

[Mikelytics · Accepted solution]

Hi @ronniesilletti 

Have already worked with the merge functionallity in Power Query?

Merge queries overview - Power Query | Microsoft Learn

or created a relationship in the data model after importing the data?

Create and manage relationships in Power BI Desktop - Power BI | Microsoft Learn

Best regards

Michael

-----------------------------------------------------

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

Appreciate your thumbs up!

@ me in replies or I'll lose your thread.