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