TIBCO Spotfire Data Connector for SAP BW fails to load data with error "External error:Unable to read beyond the end of the stream".

TIBCO Spotfire Data Connector for SAP BW fails to load data with error "External error:Unable to read beyond the end of the stream".

When the result of SAP BEx query or data selection from the TIBCO Spotfire Data Connection for SAP BW is more than 1 million cells, it may fail to load with below error in either of the two scenarios:
1) Using ODBO driver
2) Though SAP BAPI driver is installed, preference 'UseNativeSapFunctionsAllowingMoreThanOneMillionCells' have not been enabled from Administration Manager

Could not connect due to an unknown error.
External error:
Unable to read beyond the end of the stream.

  There are 2 options to resolve the issue:

1) Install the SAP BAPI driver (SAP NetWeaver RFC SDK). See "Installing BAPI driver" reference for more details

or

2) Set the 'UseNativeSapFunctionsAllowingMoreThanOneMillionCells' preferce to "True" using Administration Manager (TIBCO Spotfire Analyst > Tools > Administration Manager > Preferences > Select desired user group or Everyone on Left side > On Right side, Connectors > SAP BW) which will allow to load more than 1 million cells without any error. Doc: Installing Drivers for the SAP BW Connector

• https://docs.tibco.com/pub/sfire-analyst/7.11.0/doc/html/en-US/TIB_sfire-analyst_CubesInSpotfire/GUID-21979708-2768-473B-9656-66C17B757757.html