Input string was not in a correct format - Unexpected error on parallels desktop on Mac

[anitaberg]

BACKGROUND: I installed Power BI a while back, but tried it for the first time today. Did a re-install and have now the January 2018 version.

I get an unexpected error saying Input string was not in a correct format. The log text seems to be an issue with puting a string that is not a number to a number. But that does not say much about what is wrong.

Since I am running on Parallels Desktop on mac with Windows 10 I include that here, but I have never run into any issues in Windows before, because I am runnint that application.

I have SQL Server Express installed too.

Here is the start of the error log. I tried to goole this but found no answer. Sent a frown too.

Error Message:

Input string was not in a correct format.

Stack Trace:

System.FormatException: Input string was not in a correct format.

Server stack trace: 

   at System.Number.StringToNumber(String str, NumberStyles options, NumberBuffer& number, NumberFormatInfo info, Boolean parseDecimal)

   at System.Number.ParseInt64(String value, NumberStyles options, NumberFormatInfo numfmt)

   at Microsoft.AnalysisServices.Tabular.ImpactDataSet..ctor(DataSet data, Dictionary`2 attributes)

   at Microsoft.AnalysisServices.Tabular.ExecuteUtil.RunCommand(String commandText, IEnumerable`1 parameters, Boolean requestImpact, Int64 impactSinceVersion, Server server, ImpactDataSet& impactDataSet)

[anitaberg · Accepted solution]

I solved this it looks like by the help of this link https://support.microsoft.com/en-in/help/942460/system-formatexception-occurs-when-attempting-to-con...

I changed my region settings (under additional date, time and region settings) to English* (Australian) and Australia and then changed back to English (United States) and United States. For the first time I was able to save and import Excel data without the issue.

I will test it somewhat more, before I close the case as solved.

[javi0unavailabl]

Where you get the error?

If it is in a formula, you can cast the string to number with VALUE() https://msdn.microsoft.com/en-us/library/ee634584.aspx

[anitaberg]

Hi! I get it when I try to save a file and whenever I try to retrieve data from s Excel sheet or SQL Server. So far I believe it might be related to some registrykeys or currupted files related to SQL Server installation or analysis server installation. Because when I check a mentioned path in the error log C:\Users\xxx\AppData\Local\Microsoft\Power BI Desktop\FrownSnapShot1763945863.zip and the file msmdsrv.log the last line there is: 

(01.02.2018 14.52.04) Message: The resource file 'msmdsrvi.rll' for locale '1044' could not be loaded. Switching to US English (1033) if available. (Source: \\?\C:\Users\anitaberg\AppData\Local\Microsoft\Power BI Desktop\AnalysisServicesWorkspaces\AnalysisServicesWorkspace1348686612\Data\msmdsrv.log, Type: 3, Category: 289, Event ID: 0xC1210019) 

I have managed to uninstall everything related to SQL Server, but the issue remains.

[anitaberg]

Locale 1044 is Norwegian Bokmål. Can it be language issues with Parallels? Trying to add another language.