Hello Roger,
The AADSTS50173 error in Azure Analysis Services (AAS) indicates an expired or revoked OAuth grant/token, often due to a password change, admin revocation, or session reset since the token's issuance (2024-11-25 in your case). The TokensValidFrom date shows the cutoff—any tokens before 2025-11-10 are invalid, blocking refreshes and causing AAS processing failures. Here's how to fix it:
Quick Fix Steps
- Re-Authenticate Credentials:
- In Azure portal > Your AAS server > Data sources > Select the affected source > Edit > Re-enter username/password or service principal credentials > Save and test connection.
- For gateway sources: On-premises data gateway > Manage > Data source settings > Refresh credentials > Test.
- Clear Token Cache:
- Delete local caches:
%LOCALAPPDATA%\.IdentityService\msal.cache(or full folder) and%TEMP%\MNE*files if using tools. - Re-run AAS refresh or SSMS connection to force new token issuance.
- Delete local caches:
- Check and Reset MFA/Password:
- If password changed: Update in Entra ID > Users > Your account > Reset password (temp one, then change).
- MFA Revocation: Entra ID > Users > Sign-ins > Filter errors > If revoked, re-consent to AAS app (account.microsoft.com/security).
- Update AAS/Service Principal:
- If using SP: App registrations > Your AAS app > Certificates & secrets > New secret > Update in AAS data source.
- Portal > AAS > Overview > Restart server (quick, no downtime for creds).
- Test and Monitor:
- SSMS > Connect to AAS > Run simple query (e.g., SELECT * FROM $SYSTEM.TMSCHEMA_MEASURES).
- Sign-in logs: Entra ID > Sign-ins > Filter AADSTS50173 > Note correlation ID for support.
This regenerates fresh tokens—test immediately. If persists (e.g., multi-grant conflict), open free billing support: Portal > Help + support > New request > Issue: Authentication > "AADSTS50173 token expired" > Attach error details. Response: 1 day.
Best Regards,
Jerald Felix