M Engine error: 'Microsoft.MashupEngine; [Expression.Error] The type specified wasn't recognized.'.

[ahmedoye]

I have this error message from using ODBC to connect to a data source. My Query is unable to load because of the error.

I copied the exact same M script to Excel Power Query and it loaded without any errors.

Failed to save modifications to the server. Error returned: 'M Engine error: 'Microsoft.MashupEngine; [Expression.Error] The type specified wasn't recognized.'. '.

[Anonymous]

Perhaps you could post some code?

[ahmedoye]

= Odbc.DataSource("dsn=RST",
[HierarchicalNavigation=true,
HideNativeQuery=false,
SQLGetFunctions=[SQL_API_SQLBINDCOL=false, SQL_CONVERT_FUNCTIONS=0x2],
SqlCompatibleWindowsAuth=true,
SqlCapabilities=[LimitClauseKind=LimitClauseKind.Top,SupportsDerivedTable=true,
PrepareStatements=true,
SupportsOdbcDateLiterals=true,
SupportsNumericLiterals=true,
Sql92Conformance=8],
SQLGetInfo=[SQL_SQL_CONFORMANCE=2,
SQL_SQL92_PREDICATES=0x00001E07]]
)

Without the underlined SQLGetInfo bit, the query runs perfectly.