Forum Discussion
Impossible to Load: Token Time Out in Power Query
Hi to everyone,
I have multiple file (1 per year) loaded in Sharepoint which import and trasform data from transational excel files extracted from my CRM (divided per year). My team used those file per month and years every day with no problem, today all of them were unable to load any data and after unusal loading time they stop the import saying "token time out". Tried to do everything: duplicate file, duplicate query, load just connection and then try to re-load in table, connect disconnect, manually eliminate permission to connect to sharepoint site. Nothing works, they dont load. Other files work fine.
Please can you help me.
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!
9 Replies
Hi fgk96
Token timeout with SharePoint files usually means auth expired or refresh is taking too long.
Try this first if not already done:
- Clear SharePoint permissions : Go to File > Options > Data source settings → find your SharePoint site → Clear Permissions → reconnect with Organizational account.
- Test one small file: Copy one yearly file, keep just 100 rows, refresh that query. If it works, your full refresh is timing out.
- Check with IT: Ask if MFA/conditional access changed today on SharePoint.
Quick fix: Re-authenticate + restart Power BI usually solves it. If not, the files are too heavy for one refresh.
🌟 I hope this solution helps you unlock your Power BI potential! If you found it helpful, click 'Mark as Solution' to guide others toward the answers they need.
💡 Love the effort? Drop the kudos! Your appreciation fuels community spirit and innovation.
🎖 As a proud SuperUser and Microsoft Partner, we’re here to empower your data journey and the Power BI Community at large.
🔗 Curious to explore more? [Discover here].
Let’s keep building smarter solutions together!
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.
-
HI fgk96,
Have you had a chance to review the solution we shared earlier? If the issue persists, feel free to reply so we can help further.
Thank you.
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, I have encountered the same issue - loading tables from multiple excel files stored in sharepoint / teams folder. Loading resulted in Permission error - token refresh timed out.
Also for me the issue dissappeared a day after, but after a month it returned back again!
Tried multiple trials to solve it - what helped:
- disable "enable fast data load" in querry settings but the query takes longer time to load
- in data source settings clearing permission for the sharepoint website and define it again during next query refresh (with privacy level: none) and after it runs also with enabled fast data load. (interesting, that a month ago this did not helped at all, but now it solved the issue)
Hope it helps 🙂
