Scheduled Refresh Error with Fuzzy Matching Join

Anonymous — Mon, 06 Jul 2020 14:27:37 GMT

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.

Re: Scheduled Refresh Error with Fuzzy Matching Join

messerjc — Mon, 06 Jul 2020 15:44:28 GMT

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

Re: Scheduled Refresh Error with Fuzzy Matching Join

Anonymous — Mon, 06 Jul 2020 23:00:43 GMT

Many thanks messerjc 🙂

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

topic Re: Scheduled Refresh Error with Fuzzy Matching Join in Report Server

Scheduled Refresh Error with Fuzzy Matching Join

Re: Scheduled Refresh Error with Fuzzy Matching Join

Re: Scheduled Refresh Error with Fuzzy Matching Join