Scheduled Refresh Error with Fuzzy Matching Join

[3bdallah]

Hi All,

I'm getting a strange error when I try to refresh a Power BI Report in Report Server using Scheduled Refresh. All other reports are fine except this one because it uses the built-in fuzzyy join feature. I get below error, no clue how to fix it, is it fixable or is it a bug needs to be resolved by Microsoft ? If I refresh in PBI Desktop it works fine, If I switch off Fuzzy Mathcing it works fine.

SessionID: 0ea76ccc-46a0-4bab-b57c-c8838737ed25
[0] -1055784932: We're sorry, an error occurred during evaluation.;Could not load file or assembly 'Microsoft.DataIntegration.FuzzyMatching, Version=1.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35' or one of its dependencies. The system cannot find the file specified.
Could not load file or assembly 'Microsoft.DataIntegration.FuzzyMatching, Version=1.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35' or one of its dependencies. The system cannot find the file specified.
Could not load file or assembly 'Microsoft.DataIntegration.FuzzyMatching, Version=1.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35' or one of its dependencies. The system cannot find the file specified.
Could not load file or assembly 'Microsoft.DataIntegration.FuzzyMatching, Version=1.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35' or one of its dependencies. The system cannot find the file specified.
Could not load file or assembly 'Microsoft.DataIntegration.FuzzyMatching, Version=1.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35' or one of its dependencies. The system cannot find the file specified.. The exception was raised by the IDbCommand interface.
[1] -1055784932: The command has been canceled.. The exception was raised by the IDbCommand interface.
[2] -1055784932: The command has been canceled.. The exception was raised by the IDbCommand interface.
[3] -1055784932: The command has been canceled.. The exception was raised by the IDbCommand interface.
[4] -1055784932: The command has been canceled.. The exception was raised by the IDbCommand interface.
[5] -1055784932: The command has been canceled.. The exception was raised by the IDbCommand interface.
[6] -1055784932: The command has been canceled.. The exception was raised by the IDbCommand interface.
[7] -1055784932: The command has been canceled.. The exception was raised by the IDbCommand interface.
[8] -1055129594: The current operation was cancelled because another operation in the transaction failed.
[9] -1055784932: The command has been canceled.. The exception was raised by the IDbCommand interface.
[10] -1055784932: The command has been canceled.. The exception was raised by the IDbCommand interface.

There are no useful log files in the server.

[messerjc · Accepted solution]

Microsoft put out a new release just in the past week of the May 2020 update that I believe addressed that specific issue. I don't have a link handy to the change log notes, but if you search around here for recent issues you'll likely find it. Hope that helps!

Edit: Found it! Looks like your issue might have been resolved in the June 15th release. https://docs.microsoft.com/en-us/power-bi/report-server/changelog

[3bdallah]

Many thanks @messerjc  🙂

You just convinced me to keep reading the details of new releases, didn't expect to find this fix there.