Consultants in a BoxMicrosoft Dynamics 365MakeBusiness Central automation
Reporting and dashboards

Business Central reporting and dashboards outside Business Central

Short answer

We feed the places Business Central's own reports do not reach: a spreadsheet the board reads, a database a BI tool sits on, a weekly digest in chat. Scenarios read Business Central on a schedule, and every feed carries a check that it still matches the system it came from.

Last reviewed against the vendors' own pages. See sources.

Ways Make can read Business Central, by module

Our grouping of the module names on Make's Business Central page, read on November 17, 2026: 1 trigger, 2 searches and 1 Get action.

Show as table
ItemWays Make can read Business Central, by module
Trigger1
Searches2
Get action1

How does Business Central data reach a dashboard?

A scenario reads the records on a schedule or when something changes, shapes them, and writes them to the tool your reports are built on. Business Central stays the source of truth; the destination is a copy that is checked against it.

  1. Choose the questions the dashboard answers, and name the person who owns each number's definition.
  2. Read the data with the module that fits: Search Records (Advanced) for a precise pull, Search Records for a simple list, or Watch Records to update when a record changes.
  3. Load it into the destination: a Google Sheet, an Airtable base, or a database such as Snowflake that a BI tool like Tableau or Power BI reads. Make lists Google Sheets, Airtable, Snowflake and Tableau as apps; a BI tool can read from any database we load.
  4. Check the load: compare row counts and a control total with Business Central, and alert when they differ.
  5. Stamp the dashboard with the last successful refresh so a stale number looks stale.

Which module reads which data?

Make lists four ways to read Business Central: one trigger, two searches and one Get action. Choose by the shape of the question.

Make moduleTypeGood for
Watch RecordsTriggerReacting when records change.
Search RecordsSearchSimple lists of records by filter.
Search Records (Advanced)SearchPrecise pulls where the plain search is too blunt.
Get a RecordActionReading one record in full.
Make an API CallActionAn endpoint no dedicated module covers, such as one listed in Microsoft's API reference.

Module names are Make's. The Good for column is our guidance, not a statement from Make or Microsoft.

What makes a reporting feed trustworthy?

Five habits, built into every feed so a wrong number is caught by the feed, not by the board.

  • One written definition per metric, with an owner.
  • A row count and a control total checked against Business Central on every load.
  • A visible last-refreshed time on the dashboard.
  • An error alert to a named person when a load fails or a check differs.
  • History kept, so last quarter's number does not change when a record is edited.

What do you not do?

We do not replace Business Central's own reports or the Power BI reports you already have. If they already produce what your team needs, use them.

We add a feed only when the answer has to live somewhere else: combined with CRM or ecommerce data, shared with people who do not use Business Central, or kept as history.

Frequently asked questions

Does the feed change anything in Business Central?

No. Reporting feeds read only. We use a user that can read what the report needs and nothing else.

How fresh will the numbers be?

As fresh as the schedule you choose, and the dashboard shows when the last load succeeded. We agree the schedule after we see how much data each load moves.

Do you build the dashboards too?

We build the feed and the checks, and we can set up the dashboard in the tool you already use. We start from the questions your team asks.

Want us to look at your Business Central processes?

We build and run automations and integrations around your existing Business Central; we do not replace it. See our Business Central guides and services, and the Make Enterprise Business Central page, and the workflow automation page.

Sources

Last reviewed . Vendor plans and prices change often; every product claim and price on this page was checked against the vendor pages below on that date. Anything we could not verify was left out.

  1. Microsoft Dynamics 365 Business Central integration (Make)
  2. API (v2.0) for Dynamics 365 Business Central (Microsoft Learn)

Consultants in a Box is an independent consultancy. Microsoft Dynamics 365, Business Central and Power BI are trademarks of Microsoft; Make is a trademark of Make. This page is ours, not published or endorsed by Microsoft or Make. Module counts and names are Make's, read from its Business Central page; the grouping of modules by what they do is ours.

Which Business Central process takes the most hours?

Book a 15-minute call. Bring the one process that takes your team the most hours and we will review it with you and say how we would automate it, or tell you if we would not.

Book a free consultation

Tell us about your team and the software you need help with. We'll follow up to schedule a time to talk.

Open the form on its own page

Talk to a person

The fastest way is to pick a time. Prefer to write? Leave a message and we will email you back, usually the same business day.

Book a free call

By sending this you agree to our Terms and Privacy Policy.