Refresh fails against SQL Server

[Anonymous]

The Refresh has worked flawlessly until one week ago when the problem appeared. This is a big report with several tables from different data sources. The problematic table is from a SQL Server database. The error message i recieve is:

Failure details:
We're sorry, an error occurred during evaluation.;Unable to load language information for LocaleId 1044. Try explicitly setting the WordBreakerClassId property. Unable to load language information for LocaleId 1044. Try explicitly setting the WordBreakerClassId property. Unable to load language information for LocaleId 1044. Try explicitly setting the WordBreakerClassId property.. The exception was raised by the IDataReader interface. Table: Synergi.

Have tried to create a new report with only the SQL connection with the same SQL connection string and it refreshes without any problems.

I tried using;  SELECT '1044' AS "LCID" FROM .... rest of code;

That didn't work either. Any ideas?

[Anonymous]

Hello @Anonymous ,

I had the same problem and found a solution more or less by accident. The problem for me was, that my columns that are formatted as text were probably recognized as German (localeID 1031 is German/Germany).

Here is what I did:

I clicked on the format of the column and choose "Using locale..."

And chose Locale "English (United States)"

You might want to do this for every text column. Depending on the number of text columns this can add a lot of applied steps, so either just repeat the steps above or do it once and edit the code. The code will initially look like this:

Table.TransformColumnTypes(#"[previous Step]", {{"[name of column changed]", type text}}, "en-US")

You can insert the additional colums by adding  a comma and {"[name of additional column]", type text} between the two closing curly brackets.

I hope that helped.

[Anonymous]

Hi,

Did you find a solution to this issue? I have the same, it is refreshing in the desktop version no problem but when I refresh online I get the same error

[v-lili6-msft]

hi, @Anonymous 

If you could download the pbix file and try to refresh it in power bi desktop to check if could works well.

Best Regards,

Lin