Analytics API overview

The Analytics API for Business Central provides read-only endpoints that are optimized as data sources for Power BI apps and reports.

Use this API to extract analytical and reporting data. The Analytics API isn't intended for transactional scenarios, and it doesn't support create, update, or delete operations.

Why use the Analytics API

  • Provides read-only datasets for reporting and analysis.
  • Supports Power BI app and custom Power BI report scenarios.
  • Uses the same OAuth-based API access model as other Business Central APIs.

Power BI apps and the Analytics API

The standard Power BI apps for Business Central use the Analytics API for reading data. In the articles below, you can learn more about how each API is used for KPIs in different functional areas.

Analytics APIs by Power BI app

The following table shows which Power BI app uses each Analytics API entity.

APIUsed for analyzing
abcAnalysisSetupInventory
accountCategoryFinance
assemblyHeaderManufacturing
assemblyLineManufacturing
balanceSheetGeneralLedgerEntryFinance
binInventory
calendarEntryManufacturing
capacityLedgerEntryManufacturing
closeIncomeStmtSourceCodeFinance
closeOpportunityCodeSales
closingGeneralLedgerEntryFinance
contactSales
customerFinance, Sales
customerLedgerEntryFinance
dateSetupFinance
dimensionFinance, Sales, Purchasing, Inventory, Manufacturing, Projects, Sustainability
dimensionSetEntryFinance, Sales, Purchasing, Inventory, Manufacturing, Projects, Sustainability
dynamicDimensionFinance
fromBinWarehouseJournalLineInventory
generalLedgerAccountFinance
generalLedgerAccountCategoryFinance
generalLedgerBudgetFinance
generalLedgerBudgetEntryFinance
generalLedgerSetupFinance
incomeStatementGeneralLedgerEntryFinance
incomeStmtGeneralLedgerEntryFinance
inventoryAdjustmentEntryOrderInventory
inventoryProdOrderComponentLineManufacturing, Inventory
inventoryProdOrderLineManufacturing, Inventory
itemSales, Purchasing, Inventory, Manufacturing, Projects
itemBudgetSales
itemCategorySales, Inventory
itemJobPlanningLineProjects
itemLedgerEntryInventory, Sales
itemOutstandingPurchaseLinePurchasing
itemOutstandingSalesLineSales
itemReceivedNotInvoicedPurchaseLinePurchasing
itemShippedNotInvoicedSalesLineSales
itemValueEntryInventory
jobProjects
jobLedgerEntryProjects
jobOutstandingPurchaseLineProjects
jobPlanningLineProjects
jobReceivedNotInvoicedPurchaseLineProjects
jobTaskProjects
locationSales, Purchasing, Inventory, Manufacturing, Projects
machineCenterManufacturing
manufacturingProdOrderComponentManufacturing
manufacturingProdOrderLinesManufacturing
manufacturingProductionOrderManufacturing
manufacturingSetupManufacturing
manufacturingValueEntryManufacturing
opportunitySales
opportunityEntrySales
orderServiceLineSales
outstandingPurchaseLinePurchasing
outstandingSalesLineSales
pbiCountryRegionSustainability
pbiEmissionFeeSustainability
pbiEmployeeSustainability
pbiEmployeeAbsenceSustainability
pbiEmployeeLedgerEntrySustainability
pbiEmployeeQualificationSustainability
pbiResponsibilityCentreSustainability
pbiSustainabilityAccountSustainability
pbiSustainabilityAccountCategorySustainability
pbiSustainabilityGoalSustainability
pbiSustainabilityLedgerEntrySustainability
pbiSustainabilitySubAccountCategorySustainability
planningComponentLineManufacturing
prodItemLedgerEntryManufacturing, Inventory
prodOrderCapacityNeedManufacturing
prodOrderRoutingLineManufacturing
purchaseCreditMemoLinePurchasing
purchaseInvoiceLinePurchasing
purchaseItemBudgetEntryPurchasing
purchaseLinePurchasing
purchaseValueEntryPurchasing
requisitionLinePurchasing
resourceSales, Projects
returnReasonCodeSales, Purchasing
routingManufacturing
routingLinkManufacturing
salesCreditLineSales
salesCrProjectLedgerEntrySales, Projects
salesCycleStageSales
salesInvoiceLineSales
salesInvoiceProjectLedgerEntrySales, Projects
salesItemBudgetEntrySales
salesLineSales
salespersonPurchaserFinance, Sales, Purchasing, Projects
salesValueEntrySales
toBinWarehouseJournalLineInventory
transferLineInventory
vendorFinance, Purchasing
vendorLedgerEntryFinance
warehouseActivityLineInventory
warehouseEntryInventory
workCenterManufacturing
workCenterGroupManufacturing
workingDayManufacturing
zoneInventory

Endpoint pattern

Analytics API endpoints use the microsoft/analytics publisher and the v1.0 version:

GET https://api.businesscentral.dynamics.com/v2.0/{environmentName}/api/microsoft/analytics/v1.0/companies({companyId})/{entitySet}

For example:

GET https://api.businesscentral.dynamics.com/v2.0/{environmentName}/api/microsoft/analytics/v1.0/companies({companyId})/accountCategories

Authentication and authorization

Calls to the Analytics API require a Microsoft Entra access token and permissions to the target company data.

Next steps

  • Explore entity definitions under the Analytics API resource reference.
  • Use the corresponding GET operation pages for request and response examples.
  • Connect Power BI to these endpoints as data sources for analytics apps.

Tips for working with APIs
Enabling the APIs for Dynamics 365 Business Central
API endpoint structure
Business Central API (v2.0)
Work with Power BI in Business Central
Finance KPI overview
Power BI Sales app semantic model
KPIs and measures in the Power BI Sales app