Forum Discussion
On Premises Gateway - Windows Password Change
Hi Wikkleyn_81
The re-authentication for every single dataset (one by one) is also required even the files to be moved to the location in Sharepoint, if my understanding was correct.
Sounds like the only solution for the moment is to use a Service Account with the password set to never expire and hopefully Microsoft PBI team can make this easy in the future as I think lots of uses would be suffering from this issue if they have many datasets from different sources (excle from local file server \ sharepoint etc.).
Thanks,
Watson LIAO
What I mean is, to make it easy for re-authentication when the windows password is changed - For instance, each type of connections (File \ Analysis Services \ Web \ Folder \ Sharepoint) only needs one time of re-authentication, instead of using a Service Account with the password set to never expire.
The easiest way to update the credentials once, is to use a folder connection and then filter for the specific file you want to use in the report. That way you can use one connection for SharePoint or on a server file location.
https://learn.microsoft.com/en-us/power-bi/connect-data/service-connect-cloud-data-sources#create-a-new-shareable-cloud-connection