如何在Azure中导出Application Insights Application Map的结构化数据？是否提供相关功能或存在替代工具？

Great question—let's break this down clearly:

First, the straight answer: Azure doesn't have a built-in one-click export feature for structured data (like CSV) directly from the Application Map UI. But don't worry, there are reliable workarounds to get the data you need for your QA tasks, whether you prefer no-code/low-code options or custom scripting.

Alternative Solutions to Export Dependency Data #

1. Use Azure Monitor REST API with Kusto Queries #

Application Map is built from underlying dependency and request data stored in your Application Insights resource. You can pull this raw data using the Azure Monitor REST API, then convert it to CSV format.

Here's a quick breakdown:

• Use the /query endpoint to run a Kusto query that extracts the dependency relationships you care about. For example:

  dependencies
  | where timestamp > ago(7d) // Adjust time range to match your needs
  | project 
      SourceApplication = operation_Name, 
      TargetService = name, 
      DependencyType = type, 
      SuccessStatus = success
  | distinct SourceApplication, TargetService, DependencyType, SuccessStatus
  

• Write a simple script (PowerShell, Python, etc.) to authenticate with Azure, run the query, and export the results to a CSV file. This gives you full control over the data structure, making it easy to use for both manual reviews and automated QA workflows.

2. Export via Azure Workbooks (No-Code Option) #

If you prefer avoiding scripting, Azure Workbooks offer a straightforward way to export the data:

• Create a new workbook linked to your Application Insights resource.
• Add a "Log" query component and paste the Kusto query from above.
• Once the results load, use the Export button (top-right of the query component) to save the data as CSV, JSON, or Excel—ideal for quick manual processing or feeding into automated tools.

3. Connect to Power BI for Advanced Export & Analysis #

For more robust visualization and export capabilities:

• Connect Power BI to your Application Insights resource using the built-in connector.
• Import the dependencies table and build a report that maps out your application's integrations and dependencies.
• Export the report data directly to CSV from Power BI—this works especially well if you already use Power BI for QA-related analytics.

All these methods pull the same data that powers Application Map, so you'll get an accurate, up-to-date view of your system's integrations without manual mapping work.

内容的提问来源于stack exchange，提问作者Tamas Molnar