Auto Refresh Error For Dataset with Fuzzy Match

[Anonymous]

Hi Team,

I am getting this error while refreshing the dataset from Power Bi Service.

"We're sorry, an error occurred during evaluation.;Unable to load language information for LocaleId 1046. Try explicitly setting the WordBreakerClassId property."

When i remove the fuzzy match from the table and publish into workspace then the refresh works fine,
But i need the fuzzy match to be present in my dataset and i need to add auto/schedule refresh in the power bi service.

Can you please share your thoughts how i can make this work?

Thanks
Amit

[v-luwang-msft]

Hi @Anonymous ,

Apparently, the fuzzy match causes an error in M Language, making it impossible to refresh the report. 

After research, at this stage, there is no other method except undoing the fuzzy match:

https://community.powerbi.com/t5/Service/Unable-to-load-language-Issues-with-online-refresh/td-p/967...

https://community.powerbi.com/t5/Service/Unable-to-load-language-information-for-LocaleId-1046/m-p/1... 

Did I answer your question? Mark my post as a solution!

Best Regards

Lucien

[Anonymous]

Hi Lucien,

Thank you for your response.

I noticed that when i am trying to refresh the report with Fuzzy Match in Power bi service from my machine (India Location), i am getting this error but when my client tries to refresh the same report in Power bi service from his machine (US Location), It is getting refreshed.

I am unable to understand this logic.