Forum Discussion

zivrivkis's avatar
zivrivkis
Brass Contributor
Jan 30, 2026

Excel authentication token reuse for access to Log Analytics

I have noticed that Excel is not able to reuse the authentication token when accessing Log Analytics workspaces if an expired token was renewed for a single sheet in a workbook.

 

Scenario:

  • 1 workbook with 1+ worksheets
  • Each worksheet is a different query to LA (KQL query displayed in Excel for ease and consolidation)
  • Access to LA is protected by the usual access controls (Conditional Access; Security Reader role + Session control)
  • After a period of time, session and token expire and require renewal
  • User receives a prompt stating the token has expired and needs to be renew
  • User clicks on "Sign-in" and successfully completes the prompts (u/n+pwd+MFA)

Expected result:

  • The new token will be reused for subsequent connections to LA within the same workbook

Actual result:

  • User is prompted to re-authenticate for each and every connection in the workbook resulting in as many auth requests as there are connections

Workaround:

  • After successfully completing the first auth request, close Excel and re-open it and run "Refresh all"
  • This successfully completes refresh of all data without any additional re-auth requests

 

Is this behaviour by design or due to a configuration? Is there a way to address this so that the first token is re-used by all other connections without having to close and reopen the workbook?

No RepliesBe the first to reply

Resources