Power BI report shows expired password despite the password working from the source

[RyanSleight]

Suddenly my report started to display this error whenever I tried to refresh it. It's hooked up to an oracle database which is connected to IFS and I use SQL Dev to modify the database. The password is up to date and working in SQL Dev and I can update the view that Power BI is pulling from but the error comes up when refreshing in Power BI. Is their some way to fix this, I have even tried to re-import the data and it comes up with the error as well?

[osacapcom]

Before you do the above solution ,I was having the same issue with the same error code above , the issue start after I installed the latest Power BI version, I fix by

Opening Power BI the ==>Data source setting ==> Clear all perrmissions 

after that I entered my Oracle DB credentials and wow everything work for me .

[v-luwang-msft · Accepted solution]

Hi @RyanSleight ，

Try to connect with the users in SQL Plus, whose password has expired. it will prompt for the new password. Enter the new password and confirm password.

It will work

And you could test the below type to fix it:

open_mode from v$database

and then check:

check account_status to get mode information

and then use:

alter user myuser identified by mynewpassword account unlock;

similar refer:

https://stackoverflow.com/questions/40581131/ora-28001-the-password-has-expired 

https://stackoverflow.com/questions/9479781/ora-28001-the-password-has-expired-not-fixable 

Did I answer your question? Mark my post as a solution!

Best Regards

Lucien