Forum Discussion
Invalid Token eror on refreshing data (Power BI & Excel)
Super UserHello Mathew_Vaughan
Power BI and Excel desktop apps are showing "Invalid Token" or "Couldn't authenticate" errors when connecting to Microsoft 365 data, while browser access continues to work normally. Restarting the device temporarily resolves the issue by refreshing the token, but the error returns after a short period.
Clearing local token cache and re-authenticating in Power BI helps in some cases. Running the apps as administrator or installing the latest WebView2 runtime may also resolve the issue. If the organization uses conditional access or MFA, authentication flow interruptions may be the cause and should be reviewed by IT. A reliable workaround is to copy the query's M code and paste it into a new blank query instead of using the duplicate option.
The issue appears to have started with the June 2025 Power BI Desktop update, so checking community forums or logging a support ticket may be necessary if it continues.
If this solution helps, please accept it and give a kudos (Like), it would be greatly appreciated.
Thanks for your prompt reply.
The issue started before the June 2025 update. and does seem to be doing something post MFA.
I tried copying M queries but the issue still returned. I even put them in a dataflow, and still happens with the desktop app. I have referred the issue to our IT department and waiting back on them. I think the issue has got them stumped.
Next step would be to post a ticket with microsoft, if our IT failed to solve it.
v-aatheequeCommunity Support
Hi Mathew_Vaughan
Just checking in to see if there's been any update from your IT department regarding the issue. If the problem persists, it might be worth considering raising a support ticket with Microsoft for further investigation.
looking for further response !!
Thank You..- v-aatheeque
Hi Mathew_Vaughan
I hope you're doing well. I wanted to follow up regarding your issue with the "Invalid Token" error when retrieving data.I previously reached out to remind you about the support ticket and the potential solutions provided. If you could provide an update on your situation, it would be greatly appreciated.
If I do not hear back from you soon, I will need to close this thread in accordance with our community guidelines. However, please know that we are here to help, and I encourage you to reach out if you still need assistance.
Thank you for your understanding!
Best regards,
Atheeq.- v-aatheeque
Hi Mathew_Vaughan
I wanted to reach out one last time regarding the "Invalid Token" error you’ve been experiencing. I understand that you’ve referred the issue to your IT department and are awaiting their feedback.If you have any updates or if there’s anything further I can assist you with, please let me know. Your feedback is important, and I want to ensure we address your concerns effectively.
If we don’t hear back from you shortly, we may need to close this thread as part of our community guidelines. please know we’re always here to help so if you still need assistance or have any follow-up questions, feel free to reply at any time!
Thank you for your understanding, and I look forward to your response!