Skip to Content

Problem in displaying data from SAP HANA to Power Bi

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


Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Posted on Aug 04, 2020 at 12:22 PM

    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;

    
                    
    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.