https://catalogartifact.azureedge.net/publicartifacts/datawarenessaps1693329945614.bi-endpoints-043702f7-3f1a-482e-a75a-3248512c7cd6/783c9c5a-faef-4f86-8dc6-0d13f3269faf_BeeIconFinal300x300.png

BI Endpoints

by Datawareness ApS

Free trial badge

Simplified API endpoints for extracting Business Central data into fx. Power BI and Microsoft Fabric

BI Endpoints - Streamlined Data Access for Business Intelligence
BI Endpoints is an extension that provides a comprehensive set of pre-built API endpoints designed specifically for business intelligence and analytics workloads. Start building dashboards and data pipelines in minutes.

Why this application?
Extracting data from Business Central for reporting and analytics traditionally requires deep knowledge of the underlying table structures, relationships, and query syntax. This application eliminates this complexity by providing ready-to-use API pages that expose your business data in a clean, consistent format.

Getting started
Download our comprehensive Reference Guide for detailed setup instructions, endpoint documentation, and integration examples.
Get access to sample code and detailed endpoint reference guide in Business Central after installing the application.

Use it for
- Microsoft Power BI - Connect directly to Business Central with OAuth authentication
- Microsoft Fabric Lakehouses - Load data using Spark notebooks with built-in incremental extraction support
- Data Warehouses - Use as a standardized source for your enterprise data platform
- Custom Integrations - Access clean, well-documented APIs for any analytics tool

Key Features
- Optimized for BI - Endpoints are designed for reporting, not transactional operations
- Incremental Support - Built-in systemModifiedAt timestamps enable efficient delta loading
- Consistent Structure - All endpoints follow the same patterns and conventions
- Custom BI Endpoints - Expose data from any Business Central table as an API page without writing AL code or deploying an extension
- Comprehensive Documentation - Full reference guide with setup instructions and examples

Subscription options
- Free: Posted sales invoices and posted G/L entries for basic reporting purposes.
- Premium: 14 days free trial. Extensive data access for advanced reporting. Extensive default endpoints for Finance, Sales, Purchasing, Inventory, Jobs and Resources or configure your own custom endpoints.

Which endpoints are included?
Finance
- General Ledger Entries with full dimension support
- Chart of Accounts and G/L Account Categories
- General Ledger Budget Entries

Sales
- Customers and Customer Ledger Entries
- Posted Sales Invoices
- Posted Sales Credit Memos
- Sales Documents (quotes, orders, etc.)

Purchasing
- Vendors and Vendor Ledger Entries
- Posted Purchase Invoices and Credit Memos
- Purchase Documents (quotes, orders, etc.)

Inventory
- Items
- Item Value Entries
- Locations

Projects
- Jobs
- Job Ledger Entries

Resources
- Employees, Users and Resources
- Capacity Entries
- Time Sheets

Manufacturing
- Production Orders
- Routings
- Bill Of Materials
- Work Centers and Machine Centers
- Capacity Ledger Entries

Custom
- Define your own endpoints from any table in BC
- Extended columns
- Tables from any BC extension

At a glance

https://catalogartifact.azureedge.net/publicartifacts/datawarenessaps1693329945614.bi-endpoints-043702f7-3f1a-482e-a75a-3248512c7cd6/44f0b422-fcce-43d6-840d-a59af934f436_PowerBIParameters.png
https://catalogartifact.azureedge.net/publicartifacts/datawarenessaps1693329945614.bi-endpoints-043702f7-3f1a-482e-a75a-3248512c7cd6/c92d50d2-d889-46d9-8547-34134ccbab68_PowerBIDataloaded.png
https://catalogartifact.azureedge.net/publicartifacts/datawarenessaps1693329945614.bi-endpoints-043702f7-3f1a-482e-a75a-3248512c7cd6/f4bba89c-4fee-4077-91fe-00f9da18b67e_FabricLakehouse.png
https://catalogartifact.azureedge.net/publicartifacts/datawarenessaps1693329945614.bi-endpoints-043702f7-3f1a-482e-a75a-3248512c7cd6/b50bcba4-6e72-40cd-8c9d-9bb4c9085b13_DatawarenessBIEndpointsOverview.png
https://catalogartifact.azureedge.net/publicartifacts/datawarenessaps1693329945614.bi-endpoints-043702f7-3f1a-482e-a75a-3248512c7cd6/37c16fe8-b2b9-43b4-9b11-5642aab583c7_Postman.png