cancel
Showing results for 
Search instead for 
Did you mean: 

Problem in displaying data from SAP HANA to Power Bi

former_member694933
Discoverer
0 Kudos

After connecting SAP HANA to Power BI , only SYSTEM user can connect and every time i want to display the data from SAP HANA to power BI i get this Error message :

error old DB or odbc [SAP AG][LIBODBCHDB32 DLL][HDBODBC32] general error : 258 insufficient privileges

Note that the system user has all the privilege


dvankempen
Product and Topic Expert
Product and Topic Expert
0 Kudos

You asked a question. Don't forget to mark the answer that helped you most as correct. Thanks!

For the readers, before you leave, don't forget to up/down vote the answers. You can vote on the question too.

Thanks.

Accepted Solutions (0)

Answers (1)

Answers (1)

dvankempen
Product and Topic Expert
Product and Topic Expert
0 Kudos

Hi Aladin,

258 is a generic message. Is this the full message? We would expect an object (TABLE, VIEW, SCHEMA) returned as well.

You may assume that HANA is correct and that the user does not have the required privilege(s). Although the SYSTEM user has all built-in system privileges granted, it does not have many object privileges. When you create a table in your schema, SYSTEM will not have access for example.

Latest SAP HANA releases return a GUID, which makes it easy/ier to find out the cause

Otherwise, you can enable tracing to find out how to solve this issue.

This wiki shows an example for 258 on Tableau which may resemble your situation

Enable trace

alter system alter configuration ('indexserver.ini','SYSTEM') SET ('trace','authorization')='info' with reconfigure;

Run command

alter system alter configuration ('indexserver.ini','SYSTEM') unset ('trace','authorization') with reconfigure;