OBIEE 12c: ODBC Access From Excel 2013 Power Query Fails With Error nQSError: 10039 The driver does not support this function (Doc ID 2131268.1)

Last updated on JUNE 11, 2016

Applies to:

Business Intelligence Suite Enterprise Edition - Version 12.2.1.0.0 and later
Information in this document applies to any platform.

Goal

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 11.1.1.7 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=1.0.0.0, 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
 

Solution

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