Forum Discussion
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...
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.
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