Need help to solve the SAP HANA ODBC error

[Power_Mate]

Hi There, 

I am facing an error specifically for one table in SAP HANA DB, Where i can retrive data from other.

Please find the Error screen grab.

I thought that the table has huge data, so i tried to limit the data to 20K records or even 200 records i am facing the same error.

thanks in advance

Regrads

Power_mate

[v-easonf-msft · Accepted solution]

Hi， @Power_Mate 

The error message comes from SAP HANA itself rather than PowerBI.

Try to change the HANA DB statement_memory_limit and define the maximum permitted memory allocation.

For more details, please refer to the link below:

https://userapps.support.sap.com/sap/support/knowledge/en/3018117 

Best Regards,
Community Support Team _ Eason