Search text in a Kusto/ADX table using any number of terms from Power BI
In a table we have a free text column. Our goal is to return rows in which the text includes a list of terms which are pieces of text surrounded by special characters like comma, parentheses, space etc. We don't have such a filter in PBI so we'll use combination of a KQL operator - has_any and the mechanism of M dynamic parameters.
