"The SoftNumbers feature has not been set" Folding Error

[Anonymous]

I am running into a weird folding error that produces trace output like the following:

DataMashup.Trace Warning: 24579 : {"Start":"2018-05-31T20:22:40.3298408Z","Action":"OdbcQuery/FoldingWarning","HostProcessId":"6768","ErrorMessage":"Failed to convert from bool to int8 for expression \"isnewimplementation\". You can override this by using SqlGetInfo for converting from BIT to BIGINT.","ProductVersion":"2.58.5103.501 (PBIDesktop)","ActivityId":"4d0e0e7f-6f7a-4936-ae73-89f251bf42ee","Process":"Microsoft.Mashup.Container.NetFX40","Pid":1264,"Tid":1,"Duration":"00:00:00.0000923"}
DataMashup.Trace Warning: 24579 : {"Start":"2018-05-31T20:22:40.3299428Z","Action":"OdbcQuery/FoldingWarning","HostProcessId":"6768","ErrorMessage":"The SoftNumbers feature has not been set. You can override it by using the option parameter in Odbc.DataSource/Odbc.Query.","ProductVersion":"2.58.5103.501 (PBIDesktop)","ActivityId":"4d0e0e7f-6f7a-4936-ae73-89f251bf42ee","Process":"Microsoft.Mashup.Container.NetFX40","Pid":1264,"Tid":1,"Duration":"00:00:00.0000107"}
DataMashup.Trace Warning: 24579 : {"Start":"2018-05-31T20:22:40.3300469Z","Action":"OdbcQueryDomain/ReportFoldingFailure","HostProcessId":"6768","Exception":"Exception:\r\nExceptionType: Microsoft.Mashup.Engine1.Runtime.FoldingFailureException, Microsoft.MashupEngine, Version=1.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35\r\nMessage: Folding failed. Please take a look the information in the trace.\r\nStackTrace:\n   at Microsoft.Mashup.Engine1.Library.Odbc.OdbcQueryExpressionVisitor.VisitNumberTypeFromFunction(InvocationQueryExpression expression, Boolean isInt)\r\n   at Microsoft.Mashup.Engine1.Library.Odbc.OdbcQueryExpressionVisitor.VisitInvocation(InvocationQueryExpression expression)\r\n   at Microsoft.Mashup.Engine1.Library.Odbc.OdbcQueryExpressionVisitor.VisitValueEqualsShared(InvocationQueryExpression expression, Boolean nullable)\r\n   at Microsoft.Mashup.Engine1.Library.Odbc.OdbcQueryExpressionVisitor.VisitInvocation(InvocationQueryExpression expression)\r\n   at Microsoft.Mashup.Engine1.Library.Odbc.OdbcQueryExpressionVisitor.VisitBinary(BinaryQueryExpression binaryExpression)\r\n   at Microsoft.Mashup.Engine1.Library.Odbc.OdbcQueryExpressionVisitor.VisitBinary(BinaryQueryExpression binaryExpression)\r\n   at Microsoft.Mashup.Engine1.Library.Odbc.OdbcQueryExpressionVisitor.VisitBinary(BinaryQueryExpression binaryExpression)\r\n   at Microsoft.Mashup.Engine1.Library.Odbc.OdbcQueryExpressionVisitor.VisitBinary(BinaryQueryExpression binaryExpression)\r\n   at Microsoft.Mashup.Engine1.Library.Odbc.OdbcQueryExpressionVisitor.VisitBinary(BinaryQueryExpression binaryExpression)\r\n   at Microsoft.Mashup.Engine1.Library.Odbc.OdbcQueryExpressionVisitor.VisitBinary(BinaryQueryExpression binaryExpression)\r\n   at Microsoft.Mashup.Engine1.Library.Odbc.OdbcQuery.SelectRows(FunctionValue function)\r\n\r\n\r\n","ProductVersion":"2.58.5103.501 (PBIDesktop)","ActivityId":"4d0e0e7f-6f7a-4936-ae73-89f251bf42ee","Process":"Microsoft.Mashup.Container.NetFX40","Pid":1264,"Tid":1,"Duration":"00:00:00.0001315"}
DataMashup.Trace Warning: 24579 : {"Start":"2018-05-31T20:22:40.2286206Z","Action":"RemotePageReader/RunStub","HostProcessId":"6768","Exception":"Exception:\r\nExceptionType: Microsoft.Mashup.Engine1.Runtime.ValueException, Microsoft.MashupEngine, Version=1.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35\r\nMessage: [Expression.Error] We couldn't fold the expression to the data source. Please try a simpler expression.\r\nStackTrace:\n   at Microsoft.Mashup.Engine1.Library.Odbc.OdbcQueryDomain.ReportFoldingFailure(NotSupportedException ex)\r\n   at Microsoft.Mashup.Engine1.Library.Odbc.OdbcQuery.SelectRows(FunctionValue function)\r\n   at Microsoft.Mashup.Engine1.Runtime.OptimizingQueryVisitor.VisitQuery(Query query, Func`2 operation)\r\n   at Microsoft.Mashup.Engine1.Runtime.OptimizingQueryVisitor.VisitQuery(Query query)\r\n   at Microsoft.Mashup.Engine1.Runtime.OptimizingQueryVisitor.VisitQuery(Query query, Func`2 operation)\r\n   at Microsoft.Mashup.Engine1.Runtime.OptimizingQueryVisitor.VisitQuery(Query query)\r\n   at Microsoft.Mashup.Engine1.Runtime.OptimizingQueryVisitor.VisitQuery(Query query, Func`2 operation)\r\n   at Microsoft.Mashup.Engine1.Runtime.OptimizingQueryVisitor.VisitQuery(Query query)\r\n   at Microsoft.Mashup.Engine1.Runtime.OptimizingQueryVisitor.Optimize(Query query)\r\n   at Microsoft.Mashup.Engine1.Language.Query.QueryTableValue.get_OptimizedQuery()\r\n   at Microsoft.Mashup.Engine1.Language.Query.QueryTableValue.GetReader()\r\n   at Microsoft.Mashup.Engine.Interface.Tracing.TracingDataReaderSource.get_PageReader()\r\n   at Microsoft.Mashup.Evaluator.RemoteDocumentEvaluator.Service.<>c__DisplayClass11.<>c__DisplayClass13.<OnBeginGetDataReaderSource>b__10()\r\n   at Microsoft.Mashup.Evaluator.RemotePageReader.<>c__DisplayClass7.<RunStub>b__0()\r\n   at Microsoft.Mashup.Evaluator.EvaluationHost.ReportExceptions(IHostTrace trace, IEngineHost engineHost, IMessageChannel channel, Action action)\r\n\r\n\r\n","ProductVersion":"2.58.5103.501 (PBIDesktop)","ActivityId":"4d0e0e7f-6f7a-4936-ae73-89f251bf42ee","Process":"Microsoft.Mashup.Container.NetFX40","Pid":1264,"Tid":1,"Duration":"00:00:00.1020642"}

I am using Power BI Desktop version 2.58.5103.501 and the Amazon Redshift connector. The "IsNewImplementation" field is a boolean in the underlying Redshift connector, so I'm not sure what's going on there and why there is a conversion being attempted. Likewise, I am at a complete loss on the "SoftNumbers" issue -- I can't even find anything related to that feature anywhere on the Internet.

I am happy to provide any more details that might be helpful. I know that the Redshift connector likely isn't the most mature connector out there, and I want to do all I can to help.

[v-qiuyu-msft]

Hi @Anonymous,

From your description, it seems the issue occurs when you get data from Amazon Redshift in Power BI desktop, is there any explicit error message occur? 

It would be better please share whole desktop trace log around the time the issue occurs with us. 

Best Regards,
Qiuyun Yu

[Anonymous]

Here is a link to a Gist containing the full trace log content around when the error occurs. Let me know what else I can add that will help. https://gist.github.com/danielmklein/4cb39aa39ba2e5363410dff600ab3ced

[Anonymous]

@v-qiuyu-msft Did that Gist help at all? This is really irritating for us, as it's completely inexplicable why this report is breaking.

[Anonymous]

@v-qiuyu-msft Bump. Are there any updates or investigation done on this?