A cloud-based identity and access management service for securing user authentication and resource access
Hello MariusSundbakken-6312,
Greetings! Thanks for raising this question in Q&A forum.
Since you have already verified that the system-assigned managed identity object ID is added on the Azure Data Explorer (Kusto) side and have also tested with an Entra ID application, the 401 Unauthorized error typically indicates a cross-tenant authentication or consent issue rather than a simple permissions assignment problem.
- Verify that the managed identity from the ADF tenant is recognized as an external principal in the Kusto tenant and has been granted the required database or cluster permissions.
- Confirm that cross-tenant access settings in Microsoft Entra ID allow authentication between the ADF tenant and the Kusto tenant.
- Test authentication using a user account from the same external tenant to confirm whether the issue is specific to managed identities or affects all cross-tenant authentication methods.
- Review the Kusto cluster diagnostic logs using the provided Activity ID and ClientRequestId to identify the exact authorization failure.
- Because the error persists with both Managed Identity and Entra ID application authentication, engage the tenant administrators and Microsoft Support early, providing the Activity ID, ClientRequestId, timestamp, tenant IDs, and cluster name for backend validation.
The next action is primarily with the tenant administrators and Microsoft Support. They should validate the cross-tenant Entra ID trust configuration and review backend authentication logs to determine why the token is being rejected by the Kusto cluster.
If this answer helps you kindly accept the answer which will help others who have similar questions
Best Regards,
Jerald Felix.