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!
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