Forum Discussion

BIscoverer's avatar
BIscoverer
Helper I
5 months ago

Excel Power Query / Analysis Services authentication fails after reopening workbook

Hi everyone, I am experiencing an issue in Excel desktop when using Power Query to connect to an Analysis Services model with Microsoft Entra SSO. I am using SQL Server Analysis Services database co...
Need Help
v-menakakota's avatar
v-menakakota
Community Support
4 months ago

Hi BIscoverer ,

I think the Excel is reusing a stale Entra token from the Windows/Office auth layer (WAM) and not triggering a fresh sign-in, which is why it fails after reopen but works after clearing credentials.

Reset the local identity cache, not just Power Query credentials, sign out of Office, clear Credential Manager (Office/ADAL/Azure entries) and delete the Office identity cache folders (Identity / OneAuth). If it still fails, run an Online Repair or test with a new Windows profile. 


Best Regards, 
Community Support Team.

BIscoverer's avatar
BIscoverer
Helper I
4 months ago

Hi v-menakakota ,

Thank you for the response.

 

I have already gone through most of these steps. I've cleared credentials in Data Source Settings, cleared relevant entries in Credential Manager, performed a full Office sign-out/sign-in cycle, and had Office completely reinstalled on this machine. None of these resolved the issue persistently: credentials work after manually re-entering them, but the token does not survive a close/reopen cycle.

  • v-menakakota's avatar
    v-menakakota
    Community Support
    4 months ago

    Hi BIscoverer ,

    From what you are telling me, I think this maybe Windows auth layer (WAM) or a machine-level policy/security component interfering with token persistence. At this stage, the only meaningful checks left are to disconnect/reconnect the Work or School account in Windows, test with a new Windows profile and compare any endpoint security or GPO differences with the working machine. If it still persists, I suggest the issue with Microsoft as device level SSO/WAM issue.

    Best Regards, 
    Community Support Team.

    • v-menakakota's avatar
      v-menakakota
      Community Support
      4 months ago

      Hi BIscoverer ,

      I hope the above details help you fix the issue. If you still have any questions or need more help, feel free to reach out. We’re always here to support you.

      Best Regards, 
      Community Support Team

      • v-menakakota's avatar
        v-menakakota
        Community Support
        4 months ago

        Hi @BIscoverer ,

        I hope the above details help you fix the issue. If you still have any questions or need more help, feel free to reach out. We’re always here to support you.

        Best Regards, 
        Community Support Team