cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
RyanSleight
New Member

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

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?

 

RyanSleight_0-1655404968358.png

 

1 ACCEPTED SOLUTION
v-luwang-msft
Community Support
Community Support

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

View solution in original post

1 REPLY 1
v-luwang-msft
Community Support
Community Support

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

Helpful resources

Announcements
August 1 episode 9_no_dates 768x460.jpg

The Power BI Community Show

Watch the playback when Priya Sathy and Charles Webb discuss Datamarts! Kelly also shares Power BI Community updates.

Power BI Dev Camp Session 24 without aka link and time 768x460.jpg

Ted's Dev Camp - July 28, 2022

Watch Session 24 of Ted's Dev Camp along with past sessions!

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.