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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
ramie
Frequent Visitor

How can i create relationship between two differt tables from 2 data sources

Hi there,

 

I am new to power bi please guide me to achieve this.

I connected 2 datasources quick book online and sql and i pulled out tables also but to create relationship between the tables which is complicated form me.

I tried by merge both but the result or values are not matching, it is showing is  not correct.

Any suggesstions and guidance some one please help me.

 

Thanks in advance.

 

2 REPLIES 2
Greg_Deckler
Super User
Super User

@ramie Super difficult to say without showing us some sample data. Sorry, having trouble following, can you post sample data as text and expected output?
Not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882

Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...

Hi @Greg_Deckler ,

I already searched in the forum but not found anything. In simple terms i have 2 tables from 2 different datasources. I tried to create relationship between those 2 tables using append in power query  but not happend, values are not matched correctly.

2 tables have 1 same cloumn but values or description might not same, i applied split function to make the column similar but finally data missmatching is happend.

if not clear let me know

Please i need help on this.

 

Thanks in advance

this is how both columns looks like in both tables, how can i create relationship.

ramie_0-1678764568510.png

ramie_1-1678764611913.png

 

 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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