Skip to Content

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

Oct 02, 2017 at 03:27 AM


avatar image

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.



10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

3 Answers

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.


SAP HANA Academy

10 |10000 characters needed characters left characters exceeded
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 .


Show 1 Share
10 |10000 characters needed characters left characters exceeded

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?


Rajender Singh

avatar image
Former Member Oct 02, 2017 at 02:18 PM


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.


10 |10000 characters needed characters left characters exceeded