Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
Currently, I use Power BI to use fuzzy logic to compare a list of names with another list of names.
The raw data is imported via CSV files into Power BI Desktop, and then I use it to fuzzy logic compare at 0.65 and generate possible matches.
What I want to do:
- Automate this so, every week, the updated raw data files are automatically imported from a fixed network location, and the fuzzy logic matching undertaken, and the possible matches saved in a CSV file for me to view.
Well, for everything but the last bit, you can use Merge queries in Power Query, it has built in fuzzy matching technology.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
65 | |
63 | |
52 | |
37 | |
36 |
User | Count |
---|---|
79 | |
67 | |
60 | |
45 | |
45 |