pac analytics - Set up the export of data to App Insights from the Power Platform Admin Center using PAC CLI

[jbuenoliveira]

Context

The Power Platform Admin Center currently allows data export from Dataverse, Power Automate, Power Apps (preview), and Dynamics Customer Service (preview) to Application Insights. However, setting this up via CLI is currently not possible.

Read more: Export data to Application Insights

Idea

It would be ideal if we could create and delete data export configurations for App Insights using PAC CLI.
This feature would greatly enhance the automation of environment provisioning.

Commands

pac analytics

Usage: pac analytics [export-app-insights] [export-data-lake]

command	description
export-app-insights	Manage data exports to Application Insights.
export-data-lake	(Preview) Manage data exports to Azure Data Lake.

export-data-lake sub-command is not relevant to this discussion, but we can explore it later as an extension of the pac analytics capabilities.

---

pac analytics export-app-insights

Usage: pac analytics export-app-insights [list] [create] [delete] [show]

command	description
list	List all data exports to Azure Application Insights.
create	Create a new data export to Azure Application Insights.
delete	Delete an existing data export to Azure Application Insights.
show	Displays information about a specific data export setup.

---

pac analytics export-app-insights list

Usage: pac analytics export-app-insights list [--json]

command	description
--json	Returns the output of the command as a JSON formatted string.

API Details

API URL: [GET] https://emea.csanalytics.powerplatform.microsoft.com/api/v2/connections

---

pac analytics export-app-insights create

Usage: pac analytics export-app-insights create [--package-name] [--environment] [--subscription-id] [--resource-group-game] [--resource-name] [--settings-file]

command	description
--package-name	Name of the data export. (alias: -pn)
--environment	Specifies the target Dataverse. The value may be a Guid or absolute https URL. When not specified, the active organization selected for the current auth profile will be used. (alias: -env)
--subscription-id	Subscription id. (alias: -sb)
--resource-group-game	Resource group name. (alias: -rg)
--resource-name	Application Insights resource name. (alias: -rn)
--settings-file	The .json file with the data export package settings. (alias: -sf)

Settings File (*.json)

Dataverse diagnostics and performance:

{
  "resourceProvider": "dataverse",
  "scenarios": ["Inbound API Requests","Outbound Network Requests","Page View","Plugin executions","SDK executions","Plugin executions excep","SDK executions excep"]
}

Power Automate:

{
  "resourceProvider": "cloud flow",
  "scenarios": ["cloud flow actions","cloud flow runs","cloud flow triggers"]
}

Dynamics Customer Service:

{
  "resourceProvider": "customer service",
  "scenarios": ["default"]
}

Power Apps:

{
  "resourceProvider": "power apps",
  "scenarios": ["mobile sync", "UCI"]
}

API Details

API URL: [POST] https://emea.csanalytics.powerplatform.microsoft.com/api/v2/sinks/appinsights/connections
Sample Payload:

{
   "source": "AppInsight",
   "environments": [
      {
         "environmentId": "00000000-0000-0000-0000-000000000000",
         "organizationId": "00000000-0000-0000-0000-000000000000"
      }
   ],
   "sink": {
      "id": "/subscriptions/00000000-0000-0000-0000-000000000000/resourceGroups/resourceGroupName/providers/microsoft.insights/components/resourceName",
      "subscriptionId": "00000000-0000-0000-0000-000000000000",
      "resourceGroupName": "resourceGroupName-d-rg",
      "resourceName": "resourceName-d-appInsights",
      "key": "00000000-0000-0000-0000-000000000000"
   },
   "packageName": "package name",
   "resourceProvider": "customer service",
   "scenarios": [
      "default"
   ]
}

---

pac analytics export-app-insights delete

Usage: pac analytics export-app-insights delete [--package-name]

command	description
---package-name	Name of the data export. (alias: -pn)

API Details

API URL: [DELETE] https://emea.csanalytics.powerplatform.microsoft.com/api/v2/sinks/AppInsights/sources/AppInsight/connection/[environmentId]

---

pac analytics export-app-insights show

This option isn't available in the Power Platform Admin Center, making it difficult to verify the selected export settings.

Usage: pac analytics export-app-insights show [--package-name] [--json]

command	description
--package-name	Name of the data export. (alias: -pn)
--json	Returns the output of the command as a JSON formatted string.

---

Further deep dives are encouraged.