Analyze Open in Excel telemetry

APPLIES TO: Business Central 2026 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

DimensionDescription or value
messageOpen in Excel: {pageName} where {pageName} is the name of the page that was opened in Excel.
user_IdThe 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

DimensionDescription or value
aadTenantIdSpecifies 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.
alObjectIdSpecifies the ID of the page that was opened in Excel.
alObjectNameSpecifies the name of the page that was opened in Excel.
alObjectTypeSpecifies the type of the AL object. Value is Page.
alStackTraceThe stack trace in AL.
clientTypeSpecifies the type of client that opened the session, such as Background or Web. For a list of the client types, see ClientType Option Type.
companyNameThe current company name.
componentDynamics 365 Business Central Server
componentVersionSpecifies the version number of the component that emits telemetry.
environmentNameSpecifies the name of the tenant environment. Learn more in Managing Environments.
environmentTypeSpecifies the environment type for the tenant, such as Production or Sandbox. Learn more in Environment Types.
eventIdRT0056
extensionIdSpecifies the GUID of the extension that defines the page.
extensionNameSpecifies the name of the extension that defines the page.
extensionPublisherSpecifies the publisher of the extension that defines the page.
extensionVersionSpecifies 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
, alStackTrace = customDimensions.alStackTrace
, 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.

Monitoring and Analyzing Telemetry
Enable Sending Telemetry to Application Insights