Dataset fails to refresh in the service - Fuzzy match appears to be the problem

[MarkSL]

Hi,

I have added some Fuzzy matching logic to a report.  It works great in Desktop but when I publish it to our Premium service, the refresh fails with "Unable to connect to the data source undefined.".  When I click on Show Details I get "The import Table.FuzzyNestedJoin matches no exports. Did you miss a module reference?"

My lookup was relatively straight forward, I am simply attempting to match lots of colour codes to a core colour, eg: 'Lapiz Blue Metallic' ='Blue'.

The M Code 

    #"Perform Fuzzy Lookup to Colours" = Table.FuzzyNestedJoin(#"Renamed Columns", {"Colour"}, Colours, {"Colour"}, "Colours", JoinKind.LeftOuter, [IgnoreCase=true, IgnoreSpace=false, NumberOfMatches=1, Threshold=0.5, TransformationTable=ColourFuzzyHelper]),
    #"Expanded Colours" = Table.ExpandTableColumn(#"Perform Fuzzy Lookup to Colours", "Colours", {"Colour"}, {"Colours.Colour"}),
    #"Rename Colour.Colour to Simple Colour" = Table.RenameColumns(#"Reordered Columns",{{"Colours.Colour", "Simple Colour"}})

Thoughts appreciated!

Mark

[v-lili6-msft · Accepted solution]

hi, @MarkSL 

Could you have got the latest version of the On-Premise Gateway installed.

And if you don't use fuzzy match in edit queries, if it works well?

Best Regards,

Lin

[MarkSL]

Hi @v-lili6-msft 

Apologies for the delay in coming back to you.  Our Gateway has finally been updated today and my dataset is now refreshing as expected - so it looks like this was the issue!

Thanks

Mark