The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now
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.