Forum Discussion
Impossible to Load: Token Time Out in Power Query
Hi guys, unfortunately I've been unable to detect the issue but the problem disappeared during the night. I tried to apply all the procedure you adviced me and nothing changed, but this morning I dont know what happened, everything returned to normality for all the user and for all the files. Bit confused, I hope it was a random and single bug. I'll keep you posted if the error comes back. To the moment thank you for the support!
Could you try re-auth to your sources?
-
File > Options and settings > Data source settings
-
Select the SharePoint source(s) → Clear Permissions
-
Close Desktop completely, reopen, refresh and sign in again (Organizational account)
Also check:
-
File > Options and settings > Options > Security
-
Enable “Use my default web browser” for authentication (then restart Desktop).
Thank you for the answer, I already tried to delete authorizations and re-login but nothing changed. The problem persists indifferently by the user who launches the update
Hi fgk96,
Since clearing credentials didn’t fix the issue and it’s impacting several users, try refreshing just one file (with other yearly queries disabled) to check if the load works, as multiple SharePoint requests can sometimes lead to throttling. Make sure Privacy Levels are consistent (File → Options → Privacy). If you’re using SharePoint.Files, consider switching to SharePoint.Contents to reduce metadata load. Also, confirm with your M365 admin if there have been any recent Conditional Access or token policy changes affecting SharePoint authentication.
Thank you.
Thank you for the answer, tried to duplicate the query but simplifiying it, nothing changed. It just load something like 300 rows and the it stops. I checked with Admin as well and nothing changed in terms of permissions
