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
Resolver I
Resolver I

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.

View solution in original post

DoubleJ
Responsive Resident
Responsive Resident

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

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

November Power BI Update 768x460.png

Check it Out!

Click here to read more about the November 2021 Updates!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Kudoed Authors