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 OCTOBER 09, 2017
Applies to:Business Intelligence Suite Enterprise Edition - Version 184.108.40.206.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 220.127.116.11 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=18.104.22.168, 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
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document