ADF - Error while connecting to AppInsights REST API

Question

I am trying to copy data from AppInsights (using REST API) to a blob. I created a rest api linked service and a dataset for the app insights. The test connection is successful in the linked service :

But when I preview the data in the dataset, I get the below error -
The HttpStatusCode 403 indicates failure. {"error":{"message":"The provided credentials have insufficient access to perform the requested operation","code":"InsufficientAccessError","correlationId":"e80601cd-7510-419a-b99f-a139a1f878b6"}}
. Activity ID: f0e3cbd9-d53d-48b9-b5a3-5c570698dc01

The following are the source settings that I have.

Please let me know how I can resolve the above error, thanks!

Answer 1

Hi @Kothai Ramanathan ,

Welcome to Microsoft Q&A Platform. Thanks for posting the query.

I followed this article which explains step by step details to generate API ID and API Key which can be used to retrieve data from the AppInsights. I was able to successfully retrieve the data as below.

Hope this helps! Please let us know for further queries and we will be glad to assist.

--

• Please accept an answer if correct. Original posters help the community find answers faster by identifying the correct answer. Here is how.
• Want a reminder to come back and check responses? Here is how to subscribe to a notification.