On Premises Gateway - Windows Password Change

[_Amy_]

Hello,

I am the only person in my organisation who creates and publishes Power BI reports. 

I use an On-premies gateway to connect all my data sources.

The Authentication method I use for any excel files is my Windows username and password.

The problem is, when I have to change my password (periodically, when IT send the 'you need to change your password' emails) I have to change each data source individually.

Is there a way I can only update my new password once (for all data sources that use my credentials, rather than having to do them one by one)? 

Or, should I be asking IT to set me up with a service account where the password doesn't change? 

Thanks,

Amy

[bobo256]

Hi @_Amy_  

What did you end up doing ? Did you find a way to make it work ? 

Best,

Bo

[v-binbinyu-msft]

Hi @_Amy_ ,

So far, to my knowledge, if the password changed, you must change the credentials in Power BI Service Portal one by one.

You could try to store your data on a separate server and do not need to change the password.

Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.