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