cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ethan Visitor
Visitor

OdbcQuery/FoldingWarning Issue

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

1 REPLY 1
Community Support Team
Community Support Team

Re: OdbcQuery/FoldingWarning Issue

@ethan,

 

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

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.