Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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.
@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.
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.
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
135 | |
118 | |
101 | |
71 | |
61 |