Error in function "Table.AddFuzzyClusterColumn"

_Leo_ 96 Reputation points
2021-01-23T01:35:31.73+00:00

Hello everyone.

I notice there is a new table function in Power Query (2.84.801.0 - 64 bits -> Excel 2008 13127.21064 ), the function is "Table.AddFuzzyClusterColumn", but when I try to use this fuction PQ shows the following error: 

Error inesperado: No se puede cargar el archivo o ensamblado 'Microsoft.DataIntegration.FuzzyClustering, Version=1.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35' ni una de sus dependencias. El sistema no puede encontrar el archivo especificado.  
Detalles:  
    Microsoft.Mashup.Evaluator.Interface.ErrorException: No se puede cargar el archivo o ensamblado 'Microsoft.DataIntegration.FuzzyClustering, Version=1.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35' ni una de sus dependencias. El sistema no puede encontrar el archivo especificado. ---> System.IO.FileNotFoundException: No se puede cargar el archivo o ensamblado 'Microsoft.DataIntegration.FuzzyClustering, Version=1.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35' ni una de sus dependencias. El sistema no puede encontrar el archivo especificado. ---> System.IO.FileNotFoundException: No se puede cargar el archivo o ensamblado 'Microsoft.DataIntegration.FuzzyClustering, Version=1.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35' ni una de sus dependencias. El sistema no puede encontrar el archivo especificado.  
   en Microsoft.Mashup.Engine1.Library.FuzzyGroup.ExternalFuzzyGroup.GetRepresentativeValues(DataTable inputTable, FuzzyGroupOptions fuzzyGroupOptions, List`1 records, Int32 columnIndex)  
   en Microsoft.Mashup.Engine1.Library.FuzzyGroup.AddFuzzyClusterColumnQuery.AddFuzzyClusterColumnEnumerable.GetEnumerator()  
   en Microsoft.Mashup.Engine1.Language.Query.SkipTakeEnumerable.GetEnumerator()  
   en Microsoft.Mashup.Engine1.Language.Query.QueryTableValue.GetEnumerator()  
   en Microsoft.Mashup.Engine1.Runtime.TableValue.Microsoft.Mashup.Engine.Interface.ITableValue.GetEnumerator()  
   en Microsoft.Mashup.Evaluator.SimpleDocumentEvaluator.ValuePreviewValueSource.TableValuePreviewValueSource.SerializeRows(Int32 count)  
   en Microsoft.Mashup.Evaluator.SimpleDocumentEvaluator.ValuePreviewValueSource.TableValuePreviewValueSource.get_SmallValue()  
   en Microsoft.Mashup.Evaluator.Interface.TracingPreviewValueSource.get_SmallValue()  
   en Microsoft.Mashup.Evaluator.RemotePreviewValueSource.<>c__DisplayClass0_0.<RunStub>b__0()  
   en Microsoft.Mashup.Evaluator.EvaluationHost.ReportExceptions(IHostTrace trace, IEngineHost engineHost, IMessageChannel channel, Action action)  
   --- Fin del seguimiento de la pila de la excepción interna ---  
   en Microsoft.Mashup.Evaluator.EvaluationHost.<>c__DisplayClass11_0.<TryReportException>b__1()  
   en Microsoft.Mashup.Common.SafeExceptions.IgnoreSafeExceptions(IEngineHost host, IHostTrace trace, Action action)  
   en Microsoft.Mashup.Evaluator.EvaluationHost.TryReportException(IHostTrace trace, IEngineHost engineHost, IMessageChannel channel, Exception exception)  
   en Microsoft.Mashup.Evaluator.EvaluationHost.ReportExceptions(IHostTrace trace, IEngineHost engineHost, IMessageChannel channel, Action action)  
   en Microsoft.Mashup.Evaluator.RemotePreviewValueSource.RunStub(IEngineHost engineHost, IMessageChannel channel, Func`1 getPreviewValueSource)  
   en Microsoft.Mashup.Evaluator.RemoteDocumentEvaluator.Service.<>c__DisplayClass12_1`1.<OnBeginGetResult>b__0()  
   en Microsoft.Mashup.Evaluator.EvaluationHost.ReportExceptions(IHostTrace trace, IEngineHost engineHost, IMessageChannel channel, Action action)  
   en Microsoft.Mashup.Evaluator.RemoteDocumentEvaluator.Service.OnBeginGetResult[T](IMessageChannel channel, BeginGetResultMessage message, Action`1 action)  
   en Microsoft.Mashup.Evaluator.RemoteDocumentEvaluator.Service.OnBeginGetPreviewValueSource(IMessageChannel channel, BeginGetPreviewValueSourceMessage message)  
   en Microsoft.Mashup.Evaluator.MessageHandlers.TryDispatch(IMessageChannel channel, Message message)  
   en Microsoft.Mashup.Evaluator.ChannelMessenger.ChannelMessageHandlers.TryDispatch(IMessageChannel channel, Message message)  
   en Microsoft.Mashup.Evaluator.MessageHandlers.Dispatch(IMessageChannel channel, Message message)  
   en Microsoft.Mashup.Evaluator.ChannelMessenger.OnMessageWithUnknownChannel(IMessageChannel baseChannel, MessageWithUnknownChannel messageWithUnknownChannel)  
   en Microsoft.Mashup.Evaluator.MessageHandlers.TryDispatch(IMessageChannel channel, Message message)  
   en Microsoft.Mashup.Evaluator.ChannelMessenger.ChannelMessageHandlers.TryDispatch(IMessageChannel channel, Message message)  
   en Microsoft.Mashup.Evaluator.MessageHandlers.Dispatch(IMessageChannel channel, Message message)  
   en Microsoft.Mashup.Evaluator.EvaluationHost.Run()  
   en Microsoft.Mashup.Container.EvaluationContainerMain.Run(Object args)  
   en Microsoft.Mashup.Evaluator.SafeThread2.<>c__DisplayClass9_0.<CreateAction>b__0(Object o)  
   en Microsoft.Mashup.Container.EvaluationContainerMain.SafeRun(String[] args)  
   en Microsoft.Mashup.Container.BootstrapAppDomainManager.Execute(String[] argv)  
   --- Fin del seguimiento de la pila de la excepción interna ---  
   en Microsoft.Mashup.Evaluator.EvaluationHost.OnException(IEngineHost engineHost, IMessageChannel channel, ExceptionMessage message)  
   en Microsoft.Mashup.Evaluator.MessageHandlers.TryDispatch(IMessageChannel channel, Message message)  
   en Microsoft.Mashup.Evaluator.MessageHandlers.Dispatch(IMessageChannel channel, Message message)  
   en Microsoft.Mashup.Evaluator.ChannelMessenger.ChannelMessageHandlers.TryDispatch(IMessageChannel channel, Message message)  
   en Microsoft.Mashup.Evaluator.MessageHandlers.Dispatch(IMessageChannel channel, Message message)  
   en Microsoft.Mashup.Evaluator.Interface.IMessageChannelExtensions.WaitFor[T](IMessageChannel channel)  
   en Microsoft.Mashup.Evaluator.RemotePreviewValueSource.PreviewValueSource.WaitFor(Func`1 condition, Boolean disposing)  
   en Microsoft.Mashup.Evaluator.RemotePreviewValueSource.PreviewValueSource.get_SmallValue()  
   en Microsoft.Mashup.Evaluator.Interface.TracingPreviewValueSource.get_SmallValue()  
   en Microsoft.Mashup.Host.Document.Analysis.PackageDocumentAnalysisInfo.PackagePartitionAnalysisInfo.SetPreviewValue(EvaluationResult2`1 result, Func`1 getStaleSince, Func`1 getSampled)

I'm using an example from here: https://learn.microsoft.com/en-us/powerquery-m/table-addfuzzyclustercolumn 

Table.AddFuzzyClusterColumn(  
    Table.FromRecords(  
        {  
            [EmployeeID = 1, Location = "Seattle"],  
            [EmployeeID = 2, Location = "seattl"],  
            [EmployeeID = 3, Location = "Vancouver"],  
            [EmployeeID = 4, Location = "Seatle"],  
            [EmployeeID = 5, Location = "vancover"],  
            [EmployeeID = 6, Location = "Seattle"],  
            [EmployeeID = 7, Location = "Vancouver"]  
        },  
        type table [EmployeeID = nullable number, Location = nullable text]  
    ),  
    "Location",  
    "Location_Cleaned",  
    [IgnoreCase = true, IgnoreSpace = true]  
)

Does anyone have the same problem?

And how can I fix this issue?

Thanks in advance for the help.

Regards,

Leo.

Not Monitored
Not Monitored
Tag not monitored by Microsoft.
35,782 questions
0 comments
Accepted answer
  1. _Leo_ 96 Reputation points
    2021-03-10T04:48:43.68+00:00

    Hello Lz-3068 hope you are fine. Today MS has launched an update (Excel Version 2102 - Build 13801.20294) and seems the .dll file is not longer missing. Did a couple of tests and seems is working like a charm.

    Best regards,

    Leo.

2 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Lz._ 8,986 Reputation points
    2021-01-25T07:29:06.243+00:00

    Hi @_Leo_

    Whilst I run a more recent version of Excel/Power Query this seems very similar to something I've been experiencing - See Could not load file or assembly Microsoft.DataIntegration.FuzzyClustering

    1/ Go to %ProgramFiles%\Microsoft Office\root\Office16\ADDINS\Microsoft Power Query for Excel Integrated\bin\
    and check you have Microsoft.DataIntegration.FuzzyClustering.dll
    2/ If you don't, setup Power BI Desktop making sure you download the version that matches your Excel version (32-Bit/64-Bit)
    3/ Copy the missing dll from %ProgramFiles%\Microsoft Power BI Desktop\bin to %ProgramFiles%\Microsoft Office\root\Office16\ADDINS\Microsoft Power Query for Excel Integrated\bin\

    Not ideal but works here

    0 comments
  2. _Leo_ 96 Reputation points
    2021-01-25T18:37:19.01+00:00

    Hello Lz-3068

    Thanks for the help, it seems is the same issue that you already report... the Microsoft.DataIntegration.FuzzyClustering.dll is missing. Also the last night installed the current version (Excel 2012 - 13530.20440 and PQ 2.88.201.0 - 64 bits) and it is missing too.

    Will try your solution until MS fix this.

    Have a nice day.

    Leo.