Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.