This ODBC driver doesn't set the Sql92Conformance feature.

[QIAO]

I have set Sql92Conformance in Connector.pq as follows:

SqlCapabilities = [
PrepareStatements = true,
MaxParameters = 50,
Sql92Conformance = 2 /* SQL_SC_SQL92_ENTRY */,
GroupByCapabilities = 4 /* SQL_GB_NO_RELATION */,
FractionalSecondsScale = 3,
StringLiteralEscapeCharacters = { "\" },

SupportsTop = false,
SupportsNumericLiterals = true,
SupportsStringLiterals = true,
SupportsOdbcDateLiterals = true,
SupportsOdbcTimeLiterals = true,
SupportsOdbcTimestampLiterals = true
],

But got error report:

OdbcQuery/FoldingWarning {"Start":"2018-05-04T04:33:57.4744220Z","Action":"OdbcQuery/FoldingWarning","HostProcessId":"13960","ErrorMessage":"This ODBC driver doesn't set the Sql92Conformance feature. You can override it by using SqlCapabilities.","ProductVersion":"2.57.5068.721 (PBIDesktop)","ActivityId":"18619776-8959-40af-b74c-c9b87fd3ae69","Process":"Microsoft.Mashup.Container.NetFX40","Pid":17080,"Tid":1,"Duration":"00:00:00.0000066"}

[v-jiascu-msft]

Hi @QIAO,

Can you share your file? I tested it successfully with the demo here.

1. What's your data source?

2. Which mode did you use? Import or Direct Query?

Best Regards,

Dale

[QIAO · Accepted solution]

When I set Sql92Conformance = 8, it works.