OdbcQuery/FoldingWarning Issue

ethan — Thu, 01 Feb 2018 02:32:59 GMT

Hi Guys, I'm trying to develop a data connector with PowerBI SDK, when loading a boolean column data via ODBC driver, the PowerBI reports an error like this:

OdbcQuery/FoldingWarning {"Start":"2018-02-01T02:23:28.5133506Z","Action":"OdbcQuery/FoldingWarning","HostProcessId":"716","ErrorMessage":"Failed to convert from bit to float for expression \"C1\". You can override this by using SqlGetInfo for converting from BIT to DOUBLE.","ProductVersion":"2.54.4970.961 (PBIDesktop)","ActivityId":"298fd4a9-4f87-497b-9f93-8b3399f53fcb","Process":"Microsoft.Mashup.Container.NetFX40","Pid":6192,"Tid":1,"Duration":"00:00:00.0000394"}
OdbcQuery/FoldingWarning {"Start":"2018-02-01T02:23:28.5133984Z","Action":"OdbcQuery/FoldingWarning","HostProcessId":"716","ErrorMessage":"Failed to convert from bit to float for expression \"C1\". You can override this by using SqlGetInfo for converting from BIT to DOUBLE.","ProductVersion":"2.54.4970.961 (PBIDesktop)","ActivityId":"298fd4a9-4f87-497b-9f93-8b3399f53fcb","Process":"Microsoft.Mashup.Container.NetFX40","Pid":6192,"Tid":1,"Duration":"00:00:00.0000109"}
OdbcQuery/FoldingWarning {"Start":"2018-02-01T02:23:28.5134130Z","Action":"OdbcQuery/FoldingWarning","HostProcessId":"716","ErrorMessage":"Failed to convert from bit to float for expression \"C1\". You can override this by using SqlGetInfo for converting from BIT to FLOAT.","ProductVersion":"2.54.4970.961 (PBIDesktop)","ActivityId":"298fd4a9-4f87-497b-9f93-8b3399f53fcb","Process":"Microsoft.Mashup.Container.NetFX40","Pid":6192,"Tid":1,"Duration":"00:00:00.0000093"}
OdbcQuery/FoldingWarning {"Start":"2018-02-01T02:23:28.5134257Z","Action":"OdbcQuery/FoldingWarning","HostProcessId":"716","ErrorMessage":"Failed to convert from bit to real for expression \"C1\". You can override this by using SqlGetInfo for converting from BIT to REAL.","ProductVersion":"2.54.4970.961 (PBIDesktop)","ActivityId":"298fd4a9-4f87-497b-9f93-8b3399f53fcb","Process":"Microsoft.Mashup.Container.NetFX40","Pid":6192,"Tid":1,"Duration":"00:00:00.0000078"}
OdbcQuery/FoldingWarning {"Start":"2018-02-01T02:23:28.5134409Z","Action":"OdbcQuery/FoldingWarning","HostProcessId":"716","ErrorMessage":"Failed to convert from bit to decimal for expression \"C1\". You can override this by using SqlGetInfo for converting from BIT to DECIMAL.","ProductVersion":"2.54.4970.961 (PBIDesktop)","ActivityId":"298fd4a9-4f87-497b-9f93-8b3399f53fcb","Process":"Microsoft.Mashup.Container.NetFX40","Pid":6192,"Tid":1,"Duration":"00:00:00.0000090"}
OdbcQuery/FoldingWarning {"Start":"2018-02-01T02:23:28.5134533Z","Action":"OdbcQuery/FoldingWarning","HostProcessId":"716","ErrorMessage":"Failed to convert from bit to numeric for expression \"C1\". You can override this by using SqlGetInfo for converting from BIT to NUMERIC.","ProductVersion":"2.54.4970.961 (PBIDesktop)","ActivityId":"298fd4a9-4f87-497b-9f93-8b3399f53fcb","Process":"Microsoft.Mashup.Container.NetFX40","Pid":6192,"Tid":1,"Duration":"00:00:00.0000084"}
OdbcQuery/FoldingWarning {"Start":"2018-02-01T02:23:28.5134651Z","Action":"OdbcQuery/FoldingWarning","HostProcessId":"716","ErrorMessage":"Failed to convert from bit to bigint for expression \"C1\". You can override this by using SqlGetInfo for converting from BIT to BIGINT.","ProductVersion":"2.54.4970.961 (PBIDesktop)","ActivityId":"298fd4a9-4f87-497b-9f93-8b3399f53fcb","Process":"Microsoft.Mashup.Container.NetFX40","Pid":6192,"Tid":1,"Duration":"00:00:00.0000075"}
OdbcQuery/FoldingWarning {"Start":"2018-02-01T02:23:28.5134766Z","Action":"OdbcQuery/

But the DataSource SQLGetTypeInfo reports support BIT type, I'm not sure what happens with PowerBI, Is it MUST support CONVERT BIT to Numeric?

Thanks

Re: OdbcQuery/FoldingWarning Issue

v-chuncz-msft — Sat, 03 Feb 2018 02:55:17 GMT

@ethan,

You may try using CAST to convert data type in SQL statement.

topic Re: OdbcQuery/FoldingWarning Issue in Developer

OdbcQuery/FoldingWarning Issue

Re: OdbcQuery/FoldingWarning Issue