We are looking to embed a report for our clients with a list of company names.
They might know the companies by different names than us (we have a list of alternative names for each client) and they can also search by other identifying information like phone number, address, etc.
Many of our clients aren't English speaking and the companies have some weird names (they don't always spell correctly).
We know fuzzy grouping exists in Power BI, but can't find anything from the data filtering side.
We're looking to create a search field in our website and pass the filter along to the Power BI report, but are not sure how to do so.
Ideally, we would have a search bar pass a query to Power BI, which would then take the query and apply it as multiple or filters on the table:
| Name | Alt Name | Phone | Address |
| ABC Company Inc. | ABC Inc. | 1234567890 | 123 Walloway St |
| XYZ Holdings Inc. | ABC Solutions | 2345678901 | 124 Walloway St |
We're looking to accomplish the following (sample queries below):
- abc retrieves both rows (name or alt name from first row, alt name from second row)
- abc solutins (poorly spelled solutions) retrieves the second row (alt name mispelled)
Traditionally, we would use Levenshtein distance for the typos to find close matches.
How would we accomplish the above using Power BI? Please keep in mind that this is using the embedded feature, so we're likely to create our own form field in the web and pass it along to Power BI, not use a Power BI plugin unless absolutely necessary.
