Explore the endpoints in Business Central

With the DTW BI Endpoints Adm permission set assigned, search for BI Endpoints in Business Central. The page lists every BI endpoint available, and doubles as documentation of the Business Central data model: which source tables are used, which columns are available, and how the datasets join.

Use Category and Type to filter the list.

Endpoint details

Click an entity set name to open its details:

Field	Meaning
Source Table	The primary Business Central table for this endpoint.
Description	What data the endpoint provides.
Business Key Fields	The field or fields that uniquely identify a record, joined with &&.
URL	The full URL for this endpoint in the current environment and company.
Deleted Records URL	The full URL for retrieving deleted entries for this endpoint.
Tier	The subscription tier required: Free or Premium.
Delete Tracking	Whether deletions are tracked for this endpoint. See BI Endpoints Setup.

Below the header, three sections describe the data:

• Properties — every field in the dataset, with its caption.
• Relationships — the foreign keys in this dataset and the endpoint and primary key field each one joins to. For example, purchaseInvoiceHeaders.buyFromVendorNo joins to vendors.no.
• Referenced By — the datasets that refer to this one. For example, purchaseInvoiceLines.documentNo refers to purchaseInvoiceHeaders.no.

The same information is available as API endpoints; see Metadata discovery.

Support material

Expand the factbox pane on the BI Endpoints page to download:

Download	What it is
Reference Guide (PDF)	The reference guide for getting started.
Postman Collection (ZIP)	Every BI endpoint as a ready-made request, plus token, company list, metadata and Management API examples. See Quickstart.
Power BI template (ZIP)	A sample finance data model on the BI endpoints. See Power BI.
Fabric Spark Notebook (ZIP)	A notebook that loads the BI endpoints into a lakehouse. See Microsoft Fabric.