I connect to multiple sharepoint excel sheets stored on a team site using my organisational login through my microsoft account. To get access to this I authenticate using my Microsoft account, and choose access level as "organisational".
However, every few days when I go to refresh the report, I will get a query error saying that access is denied. To resolve this issue I have to go into data source settings, clear the stored credentials, and login again using MS credentials and selecting organisational access level. This happens to me across multiple reports, and sometimes takes time to catch the issue as they are very busy reports with many data sources.