404 Error when Performing Actions in Azure Data Explorer with Client Credentials

itay4 36 Reputation points
2024-06-13T13:48:51.8833333+00:00

I am currently working on an application that utilizes Azure Data Explorer, and I am attempting to use client credentials for authentication. While I have successfully authenticated, I encounter a 404 error whenever I attempt to perform any actions.

Here are the steps I have taken and the configurations I have made:

API Permissions:

  • Azure Data Explorer: user_impersonation
  • Microsoft Graph: offline_access, User.Read

IAM Roles:

In the Virtual Network and Subscription, I have assigned the following roles to my application:

  • Contributor
  • Owner
  • User Access Administrator

Cluster Permissions:

Under "Security and network" in the Azure Data Explorer Cluster, I have added my application with the following roles:

  • Cluster AllDatabasesAdmin
  • Cluster AllDatabasesViewer
  • Cluster AllDatabasesMonitor

Database Permissions:

For the specific database, I have assigned the following permissions to my application:

  • Database Admin
  • Database Viewer
  • Database User
  • Database UnrestrictedViewer
  • Database Ingestor
  • Database Monitor

Despite these configurations, I continue to receive a 404 error when trying to perform the  action of POST with URI template /v1/rest/query:

https://learn.microsoft.com/en-us/azure/data-explorer/kusto/api/rest/request

Could you please assist me in identifying what might be causing this issue and provide guidance on how to resolve it? Does Data Explorer’s API support this flow? 

Thank youI

Azure Data Explorer
Azure Data Explorer
An Azure data analytics service for real-time analysis on large volumes of data streaming from sources including applications, websites, and internet of things devices.
506 questions
{count} votes