Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Question Raised Previously:-
How do I get records from Table A that are not in Table B?
Answer:-
When I have tested this it works however when I use this with live data it doesn't work because not all fields are exactly the same.
E.g.
Table A Record (Lead Website)
Name = Mrs S Smith
Address = 1 Test Road, Test, TE5 73D
Email = smith@test.com
Table B Record (Database)
Name = Mrs Sandra Smith
Address = 1 Test Road, TE5 73D
Email = smith@test.com
The constant in both would be the email address, therefore is there possibly a way for us to tweak the answer above slightly to encorporate this?
Thanks,
Amie.
Power Query would be a more proper approach. Check
let LeadWebsite= Table.FromRows({{"Mrs S Smith", "1 Test Road, Test, TE5 73D", "smith@test.com"} , {"Mr Jones", "456 High Street", "789101"}}, {"Name", "Address", "Email"}), DataBase=Table.FromRows({{"Mrs Sandra Smith", "1 Test Road, Test, TE5 73D", "smith@test.com"} , {"Dr Jackson", "20 Roman Close", "xxx@xxx.com"}}, {"Name", "Address", "Email"}), RemovedRows = Table.FromList(DataBase[Email], Splitter.SplitByNothing(), {"Email"}, null, ExtraValues.Error), FilteredLeadWebsite= Table.RemoveMatchingRows(LeadWebsite,Table.ToRecords(RemovedRows) ,"Email") in FilteredLeadWebsite
In the query editor window, right click on the query list panel, right click and create a blank query.
Select the created query, open the edit window and paste the power query.
Check the steps one by one
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
6 | |
6 | |
3 | |
2 | |
2 |
User | Count |
---|---|
6 | |
5 | |
4 | |
4 | |
3 |