Skip to Content
avatar image
Rajender Singh

Change HANA DB user/password , when user login first time in Lumira or Power BI

Oct 02, 2017 at 03:27 AM | 1.3k Views | Last edit Oct 02, 2017 at 09:42 AM 2 rev.

Hi BI Experts,

We have created a DB user in HANA and now same user need to be used in POWER BI to consume the HANA models.

But their is a restriction, when user login first time, through HANA studio or HANA live browser. System ask to change the password and user can login.

However when the user try to use the credentials first time in Lumira or Power BI, It does not ask to change password and fail to login.

Regards

Rajender

SAP HANA
BW SAP HANA Modeling Tools (Eclipse) | SAP Lumira, server version for SAP HANA | SAP enhancement package for SAP ERP, version for SAP HANA
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    avatar image
    Denys van Kempen
    Oct 02, 2017 at 11:47 AM

    Hi Rajender,

    I have no system around currently to reproduce the issue but this sounds like a bug.

    If you want a solution, please log a ticket.

    If a workaround suffices, ask your SAP HANA administrator to create the user and select the option not to have to reset the password at first login (this is also available as a system-wide setting); assuming that both Lumira and Power BI have the option to change the database password.

    Denys,

    SAP HANA Academy

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Sateesh Kumar Bukkisham
    Oct 03, 2017 at 12:30 PM

    Hi Rajendar ,

    User should at least login once to HANA studio and change their password before login to any client tools .

    Sateesh

    Add comment
    10|10000 characters needed characters exceeded

    • Rajender Singh
      Oct 05, 2017 at 07:24 AM

      Hi Sateesh,

      You said correct about first login and password change.

      But we can not install HANA studio in every business user system, as nobody will be using HANA studio for their work.

      My concern is when we create user , user can not change the password them self as POWER BI tool does no give the prompt to change the password.

      We need that password change prompt?

      Regards

      Rajender Singh

  • avatar image
    Srinivas Kakarla
    Oct 02, 2017 at 02:18 PM

    Rajender,

    The login thru Lumira or Power BI is failing because the password is an initial password. There will be no prompt to change the password while trying to login outside HANA Studio. You may find details around this in the logs.

    When consuming HANA DB users, you always have to set permanent password (Change initial password) for the DB user.

    Srinivas

    Add comment
    10|10000 characters needed characters exceeded