I have a problem when using the Fuzzy Matching in powerbi Dataflow. I didn't change anything about my Dataflow, but yesterday it stopped updating with problems in the Fuzzy Matching.
An error like that: We were unable to determine how many matches the selection will return.
Until yesterday it worked.
Please make sure the columns from two tables are the same.
Add a chenge type step before fuzzy match
Note: The ABC123 means that it is an "any" data type, not text or number type.
Maybe something wrong in your datasource, try to filter the two tables with little dataset and try it again.
and also check the below link.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.