Forum Discussion

BIscoverer's avatar
BIscoverer
Helper I
4 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
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.

  • BIscoverer's avatar
    BIscoverer
    Helper I
    4 months ago

    Hi v-menakakota,

    Thank you for your suggestions.

     

    I have already reinstalled the Entra WAM plugin via PowerShell, this did not resolve the issue. 

    I think I will raise a ticket with Microsoft regarding this and will keep you updated.

  • 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

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

    Hi BIscoverer ,

    Could you please confirm if the issue has been resolved after raising a support ticket? If a solution has been found, it would be greatly appreciated if you could share your insights with the community. This would be helpful for other members who may encounter similar issues.

    Thank you for your understanding and assistance.


    Best Regards, 
    Community Support Team.