Scenario: Direct Query using ODBC Driver
When add filter, throw "Folding failed"
SqlTranslator/SqlParser/Parse {"Start":"2018-05-06T21:31:15.6637693Z","Action":"SqlTranslator/SqlParser/Parse","HostProcessId":"9640","SQL":"\nSELECT \nTOP (501) [t0].[sceneid],[t0].[courseid]\nFROM \n(\n(SELECT * FROM [modulescenesummary])\n)\n AS [t0]\nWHERE \n(\n([t0].[sceneid] IN (N'122',N'112',N'121',N'124',N'123',N'129',N'125',N'127',N'120',N'128',N'126'))\n)\n\nGROUP BY [t0].[sceneid],[t0].[courseid]\nORDER BY [t0].[courseid]\nASC\n,[t0].[sceneid]\nASC\n ","ProductVersion":"2.57.5068.721 (PBIDesktop)","ActivityId":"d747b9db-929d-48c9-b102-12596beee84e","Process":"Microsoft.Mashup.Container.NetFX40","Pid":14572,"Tid":1,"Duration":"00:00:00.0003625"}
SqlExpressionTranslator/Translate {"Start":"2018-05-06T21:31:15.6642032Z","Action":"SqlExpressionTranslator/Translate","HostProcessId":"9640","IsRecognized":"True","Result":"(environment) => Table.RenameColumns(let\r\n t826 = Table.RenameColumns(Table.PrefixColumns(environment[modulescenesummary], \"modulescenesummary\"), {{\"modulescenesummary.moduleid\", \"t0.moduleid\"}, {\"modulescenesummary.moduletitle\", \"t0.moduletitle\"}, {\"modulescenesummary.moduleversion\", \"t0.moduleversion\"}, {\"modulescenesummary.sceneid\", \"t0.sceneid\"}, {\"modulescenesummary.scenetitle\", \"t0.scenetitle\"}, {\"modulescenesummary.scenereference\", \"t0.scenereference\"}, {\"modulescenesummary.scenestarteddate\", \"t0.scenestarteddate\"}, {\"modulescenesummary.scenestoppeddate\", \"t0.scenestoppeddate\"}, {\"modulescenesummary.scenedurationtimeelapsed\", \"t0.scenedurationtimeelapsed\"}, {\"modulescenesummary.scenetrainingtimeelapsed\", \"t0.scenetrainingtimeelapsed\"}, {\"modulescenesummary.scenesuspendresumetimeelapsed\", \"t0.scenesuspendresumetimeelapsed\"}, {\"modulescenesummary.sceneinternalinterruptiontimeelapsed\", \"t0.sceneinternalinterruptiontimeelapsed\"}, {\"modulescenesummary.sceneexternalinterruptiontimeelapsed\", \"t0.sceneexternalinterruptiontimeelapsed\"}, {\"modulescenesummary.sceneinformationdurationtimeelapsed\", \"t0.sceneinformationdurationtimeelapsed\"}, {\"modulescenesummary.sceneinformationtrainingtimeelapsed\", \"t0.sceneinformationtrainingtimeelapsed\"}, {\"modulescenesummary.sceneinformationsuspendresumetimeelapsed\", \"t0.sceneinformationsuspendresumetimeelapsed\"}, {\"modulescenesummary.sceneinformationinternalinterruptiontimeelapsed\", \"t0.sceneinformationinternalinterruptiontimeelapsed\"}, {\"modulescenesummary.sceneinformationexternalinterruptiontimeelapsed\", \"t0.sceneinformationexternalinterruptiontimeelapsed\"}, {\"modulescenesummary.sceneactionsdurationtimeelapsed\", \"t0.sceneactionsdurationtimeelapsed\"}, {\"modulescenesummary.sceneactionstrainingtimeelapsed\", \"t0.sceneactionstrainingtimeelapsed\"}, {\"modulescenesummary.sceneactionssuspendresumetimeelapsed\", \"t0.sceneactionssuspendresumetimeelapsed\"}, {\"modulescenesummary.sceneactionsinternalinterruptiontimeelapsed\", \"t0.sceneactionsinternalinterruptiontimeelapsed\"}, {\"modulescenesummary.sceneactionsexternalinterruptiontimeelapsed\", \"t0.sceneactionsexternalinterruptiontimeelapsed\"}, {\"modulescenesummary.scenequestiondurationtimeelapsed\", \"t0.scenequestiondurationtimeelapsed\"}, {\"modulescenesummary.scenequestiontrainingtimeelapsed\", \"t0.scenequestiontrainingtimeelapsed\"}, {\"modulescenesummary.scenequestionsuspendresumetimeelapsed\", \"t0.scenequestionsuspendresumetimeelapsed\"}, {\"modulescenesummary.scenequestioninternalinterruptiontimeelapsed\", \"t0.scenequestioninternalinterruptiontimeelapsed\"}, {\"modulescenesummary.scenequestionexternalinterruptiontimeelapsed\", \"t0.scenequestionexternalinterruptiontimeelapsed\"}, {\"modulescenesummary.scenefeedbackdurationtimeelapsed\", \"t0.scenefeedbackdurationtimeelapsed\"}, {\"modulescenesummary.scenefeedbacktrainingtimeelapsed\", \"t0.scenefeedbacktrainingtimeelapsed\"}, {\"modulescenesummary.scenefeedbacksuspendresumetimeelapsed\", \"t0.scenefeedbacksuspendresumetimeelapsed\"}, {\"modulescenesummary.scenefeedbackinternalinterruptiontimeelapsed\", \"t0.scenefeedbackinternalinterruptiontimeelapsed\"}, {\"modulescenesummary.scenefeedbackexternalinterruptiontimeelapsed\", \"t0.scenefeedbackexternalinterruptiontimeelapsed\"}, {\"modulescenesummary.sceneassistancetimeelapsed\", \"t0.sceneassistancetimeelapsed\"}, {\"modulescenesummary.sceneactionsinteractiontimeelapsed\", \"t0.sceneactionsinteractiontimeelapsed\"}, {\"modulescenesummary.sceneactionsjustificationtimeelapsed\", \"t0.sceneactionsjustificationtimeelapsed\"}, {\"modulescenesummary.scenechoicesubmittedtimeelapsed\", \"t0.scenechoicesubmittedtimeelapsed\"}, {\"modulescenesummary.sceneshowattemptttimes\", \"t0.sceneshowattemptttimes\"}, {\"modulescenesummary.scenesuspendresumeattemptttimes\", \"t0.scenesuspendresumeattemptttimes\"}, {\"modulescenesummary.sceneinternalinterruptionattemptttimes\", \"t0.sceneinternalinterruptionattemptttimes\"}, {\"modulescenesummary.sceneexternalinterruptionattemptttimes\", \"t0.sceneexternalinterruptionattemptttimes\"}, {\"modulescenesummary.sceneinformationsuspendresumeattemptttimes\", \"t0.sceneinformationsuspendresumeatt","ProductVersion":"2.57.5068.721 (PBIDesktop)","ActivityId":"d747b9db-929d-48c9-b102-12596beee84e","Process":"Microsoft.Mashup.Container.NetFX40","Pid":14572,"Tid":1,"Duration":"00:00:00.0077092"}
SimpleDocumentEvaluator/GetResult/Evaluate {"Start":"2018-05-06T21:31:15.6636938Z","Action":"SimpleDocumentEvaluator/GetResult/Evaluate","HostProcessId":"9640","ProductVersion":"2.57.5068.721 (PBIDesktop)","ActivityId":"d747b9db-929d-48c9-b102-12596beee84e","Process":"Microsoft.Mashup.Container.NetFX40","Pid":14572,"Tid":1,"Duration":"00:00:00.0095008"}
OdbcQuery/FoldingWarning {"Start":"2018-05-06T21:31:15.6757885Z","Action":"OdbcQuery/FoldingWarning","HostProcessId":"9640","Function Name":"Group","ProductVersion":"2.57.5068.721 (PBIDesktop)","ActivityId":"d747b9db-929d-48c9-b102-12596beee84e","Process":"Microsoft.Mashup.Container.NetFX40","Pid":14572,"Tid":1,"Duration":"00:00:00.0000161"}
OdbcQuery/FoldingWarning {"Start":"2018-05-06T21:31:15.6758359Z","Action":"OdbcQuery/FoldingWarning","HostProcessId":"9640","Function Name":"PushDownQuerySpecification","ProductVersion":"2.57.5068.721 (PBIDesktop)","ActivityId":"d747b9db-929d-48c9-b102-12596beee84e","Process":"Microsoft.Mashup.Container.NetFX40","Pid":14572,"Tid":1,"Duration":"00:00:00.0000266"}
OdbcQuery/FoldingWarning {"Start":"2018-05-06T21:31:15.6761608Z","Action":"OdbcQuery/FoldingWarning","HostProcessId":"9640","ErrorMessage":"This ODBC driver doesn't set the Sql92Conformance feature. You can override it by using SqlCapabilities.","ProductVersion":"2.57.5068.721 (PBIDesktop)","ActivityId":"d747b9db-929d-48c9-b102-12596beee84e","Process":"Microsoft.Mashup.Container.NetFX40","Pid":14572,"Tid":1,"Duration":"00:00:00.0000405"}
OdbcQueryDomain/ReportFoldingFailure {"Start":"2018-05-06T21:31:15.6764580Z","Action":"OdbcQueryDomain/ReportFoldingFailure","HostProcessId":"9640","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.OdbcQuery.PushDownQuerySpecification(Boolean liftOrderBy)\r\n at Microsoft.Mashup.Engine1.Library.Odbc.OdbcQuery.Group(Grouping grouping)\r\n at Microsoft.Mashup.Engine1.Runtime.OptimizingQueryVisitor.VisitQuery(Query query, Func`2 operation)\r\n\r\n\r\n","ProductVersion":"2.57.5068.721 (PBIDesktop)","ActivityId":"d747b9db-929d-48c9-b102-12596beee84e","Process":"Microsoft.Mashup.Container.NetFX40","Pid":14572,"Tid":1,"Duration":"00:00:00.0018037"}
