Hi There, I have used Fuzzy Merge to join two data sets in Power Bi Desktop and everything went well. The refresh was also successful in Power Bi desktop. However, the dataset refresh on the ...
Hi Anonymous - I'm having the exact same issue with a fuzzy merge. The data sources in my case are:
'Users' query - from an SQL server.
'AD Users' query - from Active Directory.
I'm doing a fuzzy full outer join - M code as follows:
Source = Table.FuzzyNestedJoin(#"AD Users",{"Name", "Email Address"},Users,{"Name", "Email"},"Users",JoinKind.FullOuter,[IgnoreCase=true, IgnoreSpace=true, Threshold=0.6]),
Can you please investigate and advise? I note that fuzzy merges are a Preview feature currently but presumably they should work in Service (and I need this to work so I don't have to keep manually refreshing this dataset. Thanks
Regards, David