M365 Show -  Microsoft 365 Digital Workplace Daily

M365 Show - Microsoft 365 Digital Workplace Daily

Microsoft Data Pulse: Power BI, Fabric, Purview

How to Use Fuzzy Merge in Power Query for Similarity-Based Data Matching

Mirko Peters - M365 Specialist's avatar
Mirko Peters - M365 Specialist
Jun 18, 2025
∙ Paid
Share

If you ever need to match up records that almost—but don’t quite—look the same, Fuzzy Merge makes it easy. You can join customer or department data, even if the text entries have typos or different formats. For example, a marketing team once merged over 2,000 duplicate CRM records in just 15 minutes, and a financial firm processed a million records in u…

Keep reading with a 7-day free trial

Subscribe to M365 Show - Microsoft 365 Digital Workplace Daily to keep reading this post and get 7 days of free access to the full post archives.

Already a paid subscriber? Sign in
© 2025 Mirko Peters
Publisher Privacy ∙ Publisher Terms
Substack
Privacy ∙ Terms ∙ Collection notice
Start writingGet the app
Substack is the home for great culture