cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
DoubleJ
Responsive Resident
Responsive Resident

Connection to an Excel file in SharePoint Online: What happens when I change my AD password?

Hi

 

I use an Excel file in a SharePoint Online Document Library as a data source in my pbix file. I uploaded the report to the service and configured the data source credentials (OAouth2):

 

OAuthCredentials.png

I can setup a setup a scheduled refresh, everything works fine.

 

My question: What happens when I have to change my AD password in the future? Will I need to reenter the credentials in the Power BI Service? If so, is there a way to get informed that I have to change the pw? If I have multiple Excel files as data sources, will I need to reenter the credentials for each connection?

 

Thanks a lot in advance for your answers

JJ

 

 

 

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

Hi @DoubleJ ,

>>My question: What happens when I have to change my AD password in the future? Will I need to reenter the credentials in the Power BI Service? If so, is there a way to get informed that I have to change the pw? If I have multiple Excel files as data sources, will I need to reenter the credentials for each connection?

#1, Refresh will failed due to invalid data credentials.
#2, Yes, you need to update your credentials on power bi service side.
#3, You can consider to turn on 'send email if refresh failed' option.

Configure scheduled refresh

#4, You need to update credentials on each files if you are get data from specific files.

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

View solution in original post

3 REPLIES 3
u02cm62
Helper V
Helper V

yes you do.  Which is why you want to put it in another location so you don't have to use your account to get to it, like a service account that is available all the time with a non-expiring password.

v-shex-msft
Community Support
Community Support

Hi @DoubleJ ,

>>My question: What happens when I have to change my AD password in the future? Will I need to reenter the credentials in the Power BI Service? If so, is there a way to get informed that I have to change the pw? If I have multiple Excel files as data sources, will I need to reenter the credentials for each connection?

#1, Refresh will failed due to invalid data credentials.
#2, Yes, you need to update your credentials on power bi service side.
#3, You can consider to turn on 'send email if refresh failed' option.

Configure scheduled refresh

#4, You need to update credentials on each files if you are get data from specific files.

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.
DoubleJ
Responsive Resident
Responsive Resident

New week, new luck to get an answer? Smiley Wink

Helpful resources

Announcements
2022 Release Wave 1 760x460.png

2022 Release Wave 1 Plan

Power Platform release plan for the 2022 release wave 1 describes all new features releasing from April 2022 through September 2022.

Power BI December 2021 Update_carousel 768x460.jpg

Check it Out!

Click here to read more about the December 2021 Updates!

Top Solution Authors