Microsoft Power Platform self-service analytics schema definition (preview)
[This article is pre-release documentation and is subject to change.]
This topic discusses the contents of the data exported from Power Platform to Azure Data Lake Gen2 storage locations.
Important
- This is a preview feature.
- Preview features aren’t meant for production use and may have restricted functionality. These features are available before an official release so that customers can get early access and provide feedback.
- This feature is being gradually rolled out across regions and might not be available yet in your region.
Structure of the data output
When you export Power Apps and Power Automate inventory and usage data to your Data Lake Storage, self-service analytics makes the data available in a Common Data Model schema format. This Common Data Model-based metadata makes it possible for you to share your data across applications and business processes, such as Power Apps, Power Automate, Power BI, Dynamics 365, and Azure.
The data export file includes:
A full inventory for all apps, flows, connectors, and associated metadata that exist in the tenant.
Usage data comprising data starting from the time that the export starts.
After the first time you generate a data export, Power Automate generates incremental daily updates. Each daily update includes details about all new and existing apps, including connector information. The data export contains the Microsoft Entra principal object ID (userid). Optionally, you can further use Microsoft Entra to retrieve actual usernames and business units, such as marketing, sales, or finance.
Power Apps folder structure
The main root folder for Power Apps has the following folder structure:
- \Applications
- \ConnectionReference
- \Connections
- \Environments
- \Usage
Power Automate folder structure
The main root folder for Power Automate has the following folder structure:
- \Flows
- \FlowsConnectionReference
- \Usage
Viewing the data and folders inside Azure portal
Data listed in these folders can be viewed through your Azure portal. To learn more, go to https://portal.azure.com. Then, navigate to your storage account (Home > Subscriptions > your subscription name > Resource Groups > your resource group > your storage accounts > Storage Account).
The structure of the containers and folders inside the data lake
The main root folder is in the yyyy-mm-dd date format (for example, 2020-02-28).
The root folder contains two folders: Metadata and KPI:
- The Metadata folder contains inventory data in a list of files, one for each region.
- The KPI folder contains usage data.
Schema definition tables
The following tables detail the schema definitions of the data. Metadata are considered as inventory data.
Power Apps subfolder
Apps
| Property name | Property type | Description |
|---|---|---|
| AppName | Guid | Unique app ID that can be used to join tables |
| Name | Longtext | App name |
| Description | Longtext | App description (not available currently) |
| tenantId | Guid | Customer tenant ID |
| EnvironmentId | Longtext | Environment ID |
| Type | Longtext | App created using Power Apps |
| Subtype | Longtext | Canvas | Model | Pages |
| DocumentVersion | Datetime | The date-and-time stamp is used as the app version |
| Uri | Longtext | App URI |
| Lifecyclestate | Longtext | Draft | Published |
| DocumentUri | Longtext | App information URI |
| IconUri | Longtext | App icon URI |
| Owner | Longtext | Name of the app owner |
| createdPrincipalId | Guid | Microsoft Entra object ID of the app creator principal |
| CreatedTime | Datetime | Date the app was created |
| lastModifiedPrincipalId | Guid | Microsoft Entra object ID of last modified user |
| lastModifiedTime | Datetime | Date the app was last updated |
| lastenabledprincipalId | Guid | Microsoft Entra object ID of last published user |
| lastEnabledTime | Datetime | Date the app was last published |
| DeletedTime | Datetime | Date the app was last deleted |
| DeletedprincipalId | Longtext | Microsoft Entra object ID of the user who deleted the app |
| sharedUsers | Int | Number of users the app is shared with |
| sharedGroups | Int | Number of groups the app is shared with |
| Solution | Longtext | Solution ID the app belongs to |
| Creationtype | Longtext | Generated | Scratch development |
| embeddingHost | Longtext | Teams | Power Apps | Power BI |
| Settings | Longtext | Reserved |
| customExtensions | Longtext | Reserved |
Connection reference
| Property name | Property type | Description |
|---|---|---|
| resourceId | Guid | Unique app ID (can be used to join with the Usage table) |
| Display name | Longtext | User-entered descriptive name—for example, Office 365 Outlook |
| connectionrefId | Guid | Unique connection ID |
| EnvironmentId | Longtext | Environment ID |
| Tier | Longtext | Premium or Standard |
| Type | Longtext | Connection type—for example SQL, Office 365, or Azure |
Connections
| Property name | Property type | Description |
|---|---|---|
| ConnectionId | Guid | Unique connection ID |
| connectionName | Longtext | User-entered descriptive name—for example, Office 365 Outlook |
| apiId | Guid | Connector type |
| EnvironmentId | Longtext | Environment ID |
| Displayname | Longtext | URI of the connection |
| isCustomApi | Longtext | Yes | No |
| createdPrincipalId | Guid | Microsoft Entra object ID of the app creator principal |
| CreatedTime | Datetime | Date the app was created |
| Swaggerurl | Longtext | Swagger URL for custom API |
| tenantId | Guid | Customer tenant ID |
Environments
| Property name | Property type | Description |
|---|---|---|
| Environmentid | Longtext | Environment ID |
| name | Longtext | Environment name |
| Purpose | Longtext | Details about what the environment container was created for |
| tenantGuid | Guid | Customer tenant ID |
| Environmentstate | Longtext | Enabled | Disabled |
| environmenttype | Longtext | Sandbox | Production | Trial | Teams |
| Securitygroup | Longtext | Owner security group ID |
| Environmentregion | Longtext | Environment geo location |
| EnvironmentUrl | Longtext | Environment URL |
| isDefault | Longtext | Boolean value to indicate whether this is the default environment |
| CdsInstanceURL | Longtext | Environment URI |
| CdsInstanceId | Guid | Environment identifier |
| createdPrincipalId | Guid | Microsoft Entra object ID of the app creator principal |
| CreatedTime | Datetime | Date the app was created |
| lastModifiedPrincipalId | Guid | Microsoft Entra object ID of the user who last modified the app |
| lastModifiedTime | Datetime | Date the app was last updated |
| DeletedTime | Datetime | Date the app was last deleted |
| DeletedprincipalId | Longtext | Microsoft Entra object ID of the user who deleted the app |
Usage
| Property name | Property type | Description |
|---|---|---|
| AppId | Guid | Unique app ID (can be used to join tables) |
| environmentId | Guid | Environment ID |
| tenantId | Guid | Customer tenant ID |
| ObjectID | Guid | Microsoft Entra user object ID |
| SessionId | Guid | Session ID |
| timeaccessed | Datetime | Time the user opened or accessed the app |
| Country | Longtext | The country from which the app is opened; is filter |
| platform | Longtext | Platform or operating system from which the app is opened (see the note following this table) |
| PlayerVersion | LongText | The Power Apps player version from which the app is opened |
| AppVersion | Datetime | App version |
| Browsername | Longtext | Client browser |
| DataVersion | Int(11) | Table data, not user-related |
Power Automate subfolder
Flows
| Property name | Property type | Description |
|---|---|---|
| ResourceId | Guid | Unique flow ID (can be used to join tables) |
| name | LongText | Flow name |
| type | LongText | Power Automate |
| subtype | LongText | Cloud Flow |
| environmentId | Guid | Environment ID |
| resourceVersion | LongText | Flow version |
| lifecycleState | LongText | Draft, Published |
| events_created_timestamp | Datetime | Date the flow was created |
| events_created_principalId | Guid | Microsoft Entra object ID of the flow creator principal |
| events_lastModified_timestamp | Datetime | Date the flow was last updated |
| sharedUsers | int | Number of users the flow is shared with |
| sharedGroups | int | Number of groups the flow is shared with |
FlowsConnectionReference
| Property name | Property type | Description |
|---|---|---|
| resourceId | Guid | Unique flow ID (can be used to join tables) |
| tenantId | Guid | Customer tenant ID |
| environmentId | Guid | Environment ID |
| connectionrefId | LongText | Unique connection reference ID |
| connectorType | LongText | Type of connector used by the flow |
| connectionId | LongText | Unique connection ID |
| displayName | LongText | Name of connection reference |
| tier | LongText | Standard, Premium |
Usage
| Property name | Property type | Description |
|---|---|---|
| resourceId | Guid | Unique resource ID (can be used to join tables) |
| environmentId | Guid | Environment ID |
| tenantid | Guid | Customer tenant ID |
| timeaccessed | Datetime | Time the user opened or accessed the app |
| status | LongText | Succeeded, Failed, Cancelled, Terminated |
| subType | LongText | Cloud Flow |
| runs | Int | Number of runs |
Note
- The latest versions of generally well-known platform operating systems should contain data, but in some cases this data might not be available.
- There's a known issue for model-driven apps where the value of createdPrincipalID is null.
See also
Feedback
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see: https://aka.ms/ContentUserFeedback.
Submit and view feedback for