OBIEE 12c: ODBC Access From Excel 2013 Power Query Fails With Error nQSError: 10039 The driver does not support this function
Last updated on OCTOBER 09, 2017
Applies to:Business Intelligence Suite Enterprise Edition - Version 22.214.171.124.0 and later
Information in this document applies to any platform.
You are unable to successfully connect to OBIEE 12.2.1 via the ODBC driver with Microsoft Excel 2013 Power Query/Power Pivot whether using the 126.96.36.199 32-bit or 64-bit ODBC driver or with the 12.2.1 64-bit ODBC driver.
You have been able to successfully use this ODBC connectivity with Spotfire and have validated it with Tableau and even with MS Query and pass though queries.
Error received from ODBC Log on client:
06T20:33:17.6291659Z","Action":"Engine/IO/Odbc/Connection/GetInfo32","InfoType":"SQL_SQL_CONFORMANCE","Exception":"Exception:\r\nExceptionType: Microsoft.Mashup.Engine1.Library.Odbc.Interop.OdbcException, Microsoft.MashupEngine, Version=188.8.131.52, Culture=neutral, PublicKeyToken=31bf3856ad364e35\r\nMessage: ERROR [IM001] [NQODBC] [SQL_STATE: IM001] [nQSError: 10039] The driver does not support this function.\r\n\r\nStackTrace:\n at
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms