How to ingest data from application insights to data explorer

Malavika Nandagopan-FT 20

I added an Application Insights cluster into Data Explorer. I want to ingest data from a database inside that cluster. But it seems that I'm not authorized to access that database. The suggested solution was to navigate to the permission tab and grant permission. But the permission tab is missing from the menu.

User's image

AnuragSingh-MSFT 21,236 Reputation points

2023-02-24T11:03:46.2733333+00:00
@Malavika Nandagopan-FT Thank you for reaching out to Microsoft Q&A.

Can you please share additional details about the question, like

How did you add Application Insights cluster to Data Explorer? Is there a doc link that you followed?

Can you please share the link where the suggested solution to "..navigate to permission.." was mentioned?

I am trying to get this because data in Applicaiton Insights workspace is collected either via SDK or through Application Insights API. I am not aware of a way where you can directly import the data in AppInsights Cluster.

Please let me know if you have any questions.
Malavika Nandagopan-FT 20 Reputation points

2023-02-27T08:31:35.0233333+00:00
@AnuragSingh-MSFT

I followed this https://video2.skills-academy.com/en-us/azure/data-explorer/query-monitor-data to add Application Insights cluster to Data Explorer.

This is the link to the suggested solution : https://video2.skills-academy.com/en-us/azure/data-explorer/manage-database-permissions
PRADEEPCHEEKATLA-MSFT 84,381 Reputation points Microsoft Employee

2023-02-27T08:37:10.02+00:00

@Malavika Nandagopan-FT Could you please check the document shown at the error message and see if you are able to resolve the issue?

And also, confirm your permission on the Database named app-reports-qa1?
Malavika Nandagopan-FT 20 Reputation points

2023-02-27T09:57:07.38+00:00

@PRADEEPCHEEKATLA-MSFT

I did check the document shown at the error message but that didn't solve the problem.
PRADEEPCHEEKATLA-MSFT 84,381 Reputation points Microsoft Employee

2023-02-27T10:01:56.55+00:00

@Malavika Nandagopan-FT Can you please confirm your permission of the cluster QA Report ai server and Database named app-reports-qa1?
Malavika Nandagopan-FT 20 Reputation points

2023-02-28T08:29:01.2066667+00:00

@PRADEEPCHEEKATLA-MSFT

I am trying out the free data explorer and it doesn't have that option. I created a free cluster in this: https://dataexplorer.azure.com/
PRADEEPCHEEKATLA-MSFT 84,381 Reputation points Microsoft Employee

2023-02-28T08:38:29.87+00:00

@Malavika Nandagopan-FT I had tried to create a free data explorer cluster and able to Ingest data into table without any issue?

Could you please confirm if you are the owner of the free data explorer cluster named: QA Report ai?
Malavika Nandagopan-FT 20 Reputation points

2023-02-28T14:28:28.85+00:00

@PRADEEPCHEEKATLA-MSFT That is the default database provided by them which I too can ingest. But it is the QA Report Ai database that I don't have permission over. Also, I don't have any option to check the permissions.
PRADEEPCHEEKATLA-MSFT 84,381 Reputation points Microsoft Employee

2023-02-28T14:39:12.53+00:00

@Malavika Nandagopan-FT Could you please help me understand - who is the owner of ADX cluster: QA Report ai?
Malavika Nandagopan-FT 20 Reputation points

2023-03-01T06:20:20.24+00:00

@PRADEEPCHEEKATLA-MSFT How do I check who the owner is?
PRADEEPCHEEKATLA-MSFT 84,381 Reputation points Microsoft Employee

2023-03-01T06:45:53.05+00:00

@Malavika Nandagopan-FT Could you please share the screenshot by selecting MyClusters(Preview)?
Malavika Nandagopan-FT 20 Reputation points

2023-03-01T09:41:08.78+00:00

@PRADEEPCHEEKATLA-MSFT
PRADEEPCHEEKATLA-MSFT 84,381 Reputation points Microsoft Employee

2023-03-02T15:22:06.32+00:00

@Malavika Nandagopan-FT Glad to know that the below response was helpful. Thank you for marking this answer as accepted. This will help others find useful answers faster.

Please feel free to take a survey on the relevant answer. You can help us improve by leaving feedback verbatim.

Have a good day!

Regards,

PRADEEPCHEEKATLA-MSFT

Accepted answer

PRADEEPCHEEKATLA-MSFT 84,381 Reputation points Microsoft Employee

2023-03-02T06:30:09.38+00:00

Under ADX free clusters - you have only one cluster named MyFreeCluster - you are allowed to ingest data into MyFreeCluster and you will not have accesss to any other ADX clusters.

I'm not sure - how are able to select ADX cluster: QA Report ai?

You can ingest data using MyFreeCluster without any issue.

Hope this helps. Do let us know if you any further queries.

If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.
Please sign in to rate this answer.
Malavika Nandagopan-FT 20 Reputation points

2023-03-02T06:31:26.3466667+00:00

@PRADEEPCHEEKATLA-MSFT Okay. Thank you for helping me out.

PRADEEPCHEEKATLA-MSFT 84,381 Reputation points Microsoft Employee

2023-03-02T06:36:35+00:00

@Malavika Nandagopan-FT

Glad to know it helped. Do cick on Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.
Sign in to comment

1 additional answer

Deleted

This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.

Comments have been turned off. Learn more

Share via

How to ingest data from application insights to data explorer

1 additional answer