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!
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
Hi fgk96,
Since the query loads some rows and then stops for several users, it seems the connection is established but the refresh might be timing out when accessing SharePoint files. You can try connecting directly to a single SharePoint file to check if the issue happens during folder enumeration. If the same problem occurs with a simplified query, you may want to open a Microsoft support ticket to review backend logs.
Create a Fabric and Power BI Support Ticket - Power BI | Microsoft Learn
Thank you.