Forum Discussion
Input string was not in a correct format - Unexpected error on parallels desktop on Mac
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)
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-convert-a-numeric-str
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.
4 Replies
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
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.
Locale 1044 is Norwegian Bokmål. Can it be language issues with Parallels? Trying to add another language.
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-convert-a-numeric-str
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.
