To remove a Data Source in Google Sheets, please do the following steps:
1. Go to the sidebar, click on Data Source, select the data source and the small arrow on the side, and click on log out all.
2. Click on log out one more time to confirm.
To force a refresh for account data, please see this guide.