Share via

Tables loading failed in Azure Data Explorer (Kusto) dataset

Narender Gavinolla 0 Reputation points Microsoft External Staff
2023-08-23T22:33:37.1+00:00

Hi,

Im trying preview the data using Azure Data Explorer (Kusto) dataset from one of the external data source.

Created linked service and dataset for the source side using service princple(SPN) and SPN has view access.

tables are not loading in dataset and giving error Caller is not authorized to perform this action Principal 'aaduser my id'.

Thanks,

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.
561 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
11,429 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. ShaikMaheer-MSFT 38,521 Reputation points Microsoft Employee
    2023-08-30T10:47:42.9166667+00:00

    Hi Narender Gavinolla (Harman Connected Services Inc),

    Thank you for posting query in Microsoft Q&A Platform.

    From error message, it seems the account you are using not have permissions. Kindly try assigning required permissions such as Database Admin or any other to query data from ADX tables and then re-try and see.

    Hope this helps. Please let me know if any further queires.

    Please consider hitting Accept Answer button. Accepted answers help community as well.

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.