For excel spreadsheets created by Arthur and Laurence
if you get this error: Loading assembly file ... failed for data source type 'SQL'
Please go to the source data settings and update it from manual account to integrated windows credentials "Use my current credentials" which picked up from your account. Even if you change the password it won't affect anything.
On top of that if the credentials are saved within the file it won't be used by any other user.