Forum Discussion
Direct Query SAP HANA Credential Lockout
HI Anonymous,
For 'direct query' mode data source, you need to keep its data credentials valid. (notice: it refreshed triggered every time users interact with visuals or table records)
So if you change your credentials on Datasource side, you also need to update your data source credentials on power bi service dataset side.
For local report file changes that apply to power bi desktop, it does not interact with published power bi service contents.Regards,
Xiaoxin Sheng
Hi Anonymous ,
I've the same problem once.
My password used to get locked if I input it wrong for 3x and I was pulling data from at least 4 tables from Hana.
Try to check it and you can use parameters to change the user and password online. Maybe it helps you.
Ricardo
Hey camargos88 ,
That makes sense. I was able to change the user and password login online for the cluster and that solved the issue. Was I supposed to do that before or after I change the user/password on the report file itself?
If I change the password for my credentials online first, then do I have to close any related Power BI files beforehand?
Anonymous ,
No, if it's online it's another version,.... there is no relation with the file on your computer.
Ricardo
HI Anonymous,
For 'direct query' mode data source, you need to keep its data credentials valid. (notice: it refreshed triggered every time users interact with visuals or table records)
So if you change your credentials on Datasource side, you also need to update your data source credentials on power bi service dataset side.
For local report file changes that apply to power bi desktop, it does not interact with published power bi service contents.Regards,
Xiaoxin Sheng