Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
APPLIES TO: Business Central 2024 release wave 2 and later
Open in Excel telemetry gathers data about when users export data from Business Central to Excel using the Open in Excel action. Learn more in Open in Excel.
Open in Excel
Occurs when a user successfully opens a page in Excel.
General dimensions
| Dimension | Description or value |
|---|---|
| message | Open in Excel: {pageName} where {pageName} is the name of the page that was opened in Excel. |
| user_Id | The user telemetry ID for the user. From the user card, you can use user_Id to identify the user who triggered this telemetry event. Learn more in Assign a telemetry ID to users. |
Custom dimensions
| Dimension | Description or value |
|---|---|
| aadTenantId | Specifies the Microsoft Entra tenant ID used for Microsoft Entra authentication. For on-premises, if you aren't using Microsoft Entra authentication, this value is common. |
| alObjectId | Specifies the ID of the page that was opened in Excel. |
| alObjectName | Specifies the name of the page that was opened in Excel. |
| alObjectType | Specifies the type of the AL object. Value is Page. |
| clientType | Specifies the type of client that opened the session, such as Background or Web. For a list of the client types, see ClientType Option Type. |
| companyName | The current company name. |
| component | Dynamics 365 Business Central Server |
| componentVersion | Specifies the version number of the component that emits telemetry. |
| environmentName | Specifies the name of the tenant environment. Learn more in Managing Environments. |
| environmentType | Specifies the environment type for the tenant, such as Production or Sandbox. Learn more in Environment Types. |
| eventId | RT0056 |
| extensionId | Specifies the GUID of the extension that defines the page. |
| extensionName | Specifies the name of the extension that defines the page. |
| extensionPublisher | Specifies the publisher of the extension that defines the page. |
| extensionVersion | Specifies the version of the extension that defines the page. |
Sample KQL code
traces
| where timestamp > ago(60d)
| where customDimensions.eventId == 'RT0056'
| project timestamp
, message
, aadTenantId = customDimensions.aadTenantId
, environmentName = customDimensions.environmentName
, environmentType = customDimensions.environmentType
, companyName = customDimensions.companyName
, clientType = customDimensions.clientType
, alObjectId = customDimensions.alObjectId
, alObjectName = customDimensions.alObjectName
, extensionName = customDimensions.extensionName
, extensionPublisher = customDimensions.extensionPublisher
, extensionVersion = customDimensions.extensionVersion
To learn more about how to set up alerting on Business Central telemetry, see Alert on Telemetry.
Related information
Monitoring and Analyzing Telemetry
Enable Sending Telemetry to Application Insights