Target data freshness
Connected Business Central reporting, with data freshness agreed and validated during onboarding.
DYNAMICS 365 BUSINESS CENTRAL REPORTING
Business Central reporting that grows with your business.
Turn Business Central data into customisable Power BI reporting on Microsoft Fabric. Connect finance, receivables, payables, inventory and sales, with hosting and ongoing support available.
An assisted implementation, prepared around your sources and business rules. Scope, pricing and delivery targets are agreed before setup.A FASTER START. ROOM TO MAKE IT YOURS.
Useful reports first. The flexibility to go further.
Move from repeated exports to a connected view of your companies, customers, suppliers and stock. Start with a defined reporting pack, then adapt account mappings, dimensions and report layouts to the decisions your team needs to make.
Target reporting-suite delivery
An agreed standard pack, with reports your team can customise.
Targets apply to agreed standard reporting packs once source access, required mappings and scope are confirmed. Initial data loads, custom extensions, complex consolidation and additional integrations can change the timing. We validate data freshness and agree delivery dates for your environment before implementation.
CHOOSE YOUR REPORTING STARTING POINT
From the general ledger to the goods leaving your warehouse.
Choose the reporting areas that matter first. We agree the report list, source tables, measures and company scope, then configure the pack for your business.
Finance and general ledger
P&L, balance sheet and account movements, shaped around your chart of accounts, dimensions and agreed company scope.
Accounts payable
Vendor balances, aged payables and outstanding invoices. See upcoming payment requirements and drill into the entries behind the totals.
Accounts receivable
Customer balances, aged receivables and overdue invoices. Follow posted sales into outstanding debt and collection priorities.
Inventory and stock
Item availability, ledger movements and inventory value. Explore stock by the agreed locations, item groups and reporting cutoffs.
Sales and shipping
Orders, posted sales and shipments in a connected view. Understand what has been ordered, shipped and invoiced across your agreed companies.
Purchasing and vendors
Purchase orders, receipts and vendor activity. Compare purchasing commitments with the stock and financial information behind them.
These are reporting areas to include in your agreed pack. The two-week target covers the standard scope agreed upfront. Additional custom reports, extensions and integrations are quoted separately where needed.
CUSTOMISE THE SUITE
Your accounts. Your dimensions. Your view of performance.
Adapt report layouts, drilldowns and agreed measures without rebuilding the entire reporting foundation. Reconcile the starting point, then develop it around the questions your team asks.
- Business Central companies, reporting periods and currencies
- Chart of accounts, dimensions and management reporting groups
- Customer, vendor, item and location mappings
- Posted entries, document dates and agreed reporting cutoffs
THE BUSINESS LOGIC BEHIND THE NUMBERS
More than a connection. A reporting foundation.
The value is in how the data is prepared and defined. We configure the account mappings, relationships and KPI definitions that turn your Dynamics records into useful reporting.
- BRONZE
Connect the source
Bring the agreed Dynamics tables into Fabric with their source context.
- SILVER
Clean and connect
Align companies, accounts, documents and dimensions into consistent relationships.
- GOLD
Apply your rules
Prepare reconciled reporting data around your accounting and operational definitions.
- REPORTS, AI AND APPS
Put the data to work
Use governed semantic models for Power BI, planning and Nova AI Analyst through MCP.
Bronze, Silver and Gold describe the preparation layers. Direct Lake reads the prepared Fabric data without a full import refresh. End-to-end freshness still depends on the source connection, transformations and semantic model updates. AI answers use configured context and still need human review.
How we prepare your business contextFROM ONBOARDING TO A WORKING SUITE
A clear implementation plan, agreed before we start.
We target two weeks for a standard first reporting suite once source access, mappings and scope are confirmed. Your agreed delivery plan defines exactly what is included.
- 01
Agree the pack and connection
Confirm reporting priorities, company scope, permissions, source tables and delivery targets. Identify custom work before setup.
- 02
Prepare, model and reconcile
Configure Bronze, Silver and Gold preparation, account mappings and semantic models. Check totals and source-to-report freshness.
- 03
Review, customise and hand over
Walk through the reports with finance and operations. Confirm access, drilldowns and the responsibilities for running the suite.
Your connection and data freshness
We confirm whether you use Business Central online or on-premises, your version, extensions and permitted interfaces. Where available and suitable, Business Central mirroring can feed Fabric. Otherwise, we scope an appropriate API or supported connector and its achievable update frequency. Mirroring availability and preview conditions are checked during setup.
Direct Lake supports reporting over prepared Fabric data. We measure the full source-to-report journey before confirming the freshness target for your connection.
IMPLEMENTATION OR AN ONGOING SERVICE
We can handle the hosting and the reporting.
Choose a scoped reporting implementation or ask DataNova to run the analytics environment, pipelines and reporting through Managed BI. The platform subscription is included in Managed BI.
Know the investment before setup.
Your quote separates implementation, the included platform plan, hosting and ongoing support. Source licences, capacity requirements and any additional integration costs are confirmed upfront.
TAKE THE WORKSHEET TO YOUR NEXT MEETING
Business Central Reporting Pack Guide
A specification and acceptance workbook for finance, sales and stock.
Agree the scope, source controls, business definitions and acceptance evidence before starting the build. Read the free guide online or download the printable PDF.
Open the reporting guideSTART WITH YOUR PROCESS
Let's plan your Business Central reporting.
Share your requirements. No card or commitment.
Describe the result you need and the information you work with. We can help you identify a suitable existing application or scope a tailored pilot.
- Share the problem and your data sources.
- Discuss the workflow and a practical starting point.
- Agree the scope, costs and trial route.
A card is required when you start a trial. An enquiry does not start a subscription or commit you to a project.
EVALUATE THE RIGHT FIT
Try the application before committing to the next step.
Both assisted routes include a 30 day free trial, starting after onboarding and environment setup. Card required at signup. No charge until your 30 day trial ends.
Start without an implementation fee.
If an existing application meets your requirements without additional mapping or implementation, implementation and the 30 day trial are free. Normal subscription charges begin after the trial, under your agreed terms.
Agree the full quote before the pilot.
We agree the application, mapping, workflows and implementation quote upfront. We then prepare the agreed pilot for your 30 day free trial. If you choose to proceed afterwards, the quoted implementation fee and monthly subscription become payable.
We confirm the pilot deliverables, preparation, trial start and decision process together. Any work beyond the agreed pilot scope is discussed separately.
PRACTICAL ANSWERS
Before we connect your Dynamics data.
Does this work with Business Central online and on-premises?
We assess both, but the connection and achievable data freshness depend on the deployment, version, permissions and available interfaces. We confirm a supported extraction route and the initial reporting scope before agreeing your implementation.
Can you use Business Central mirroring into Fabric?
Native Business Central mirroring requires a Fabric workspace in the same Microsoft Entra tenant as Business Central. We assess its availability, version, permissions and preview conditions where that setup is suitable. For DataNova-hosted reporting across tenants, we scope an appropriate API, supported connector or approved data-sharing route and validate the achievable update frequency during onboarding.
Can we include multiple companies and custom dimensions?
Yes, where the required data is available through the agreed connection. We map your company structures, accounts and dimensions, then check reporting totals against Business Central. Extension tables, currency translation and consolidation requirements are scoped separately where needed.
How fresh will our Business Central reporting be?
We agree and validate data freshness during onboarding for your Business Central environment. The achievable update frequency depends on the connection, required tables, data volumes, data preparation, Fabric capacity and semantic model updates. Initial historical loads can take longer. We confirm a realistic source-to-report refresh target before implementation.
Can our reporting suite be ready within two weeks?
We target a customisable first reporting suite within two weeks for agreed standard packs once source access, required mappings and scope are confirmed. We agree the reports and delivery date upfront. Custom extensions, complex consolidation, additional integrations or delayed access can require a longer implementation.
Can we customise the reports and add planning or AI?
Yes. Configure report layouts, measures and drilldowns around your agreed business definitions, and extend the suite with budgets, forecasts or business applications. Nova AI Analyst uses configured semantic models and MCP to work with your business context. AI answers still need review. Additional modelling, connections and applications are scoped with you.
What does the reporting investment include?
Your quote separates the platform subscription, any implementation or mapping work, and the agreed hosting and ongoing support. Managed BI includes the platform subscription. Source-system licences and any additional capacity or integration costs are confirmed upfront. Your assisted trial begins after onboarding and environment setup, under the assisted trial terms shown on this page.
CONTINUE EXPLORING
All Dynamics reporting options