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.
- Choose the questions the dashboard answers, and name the person who owns each number's definition.
- 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.
- 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.
- Check the load: compare row counts and a control total with Business Central, and alert when they differ.
- 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 module | Type | Good for |
|---|---|---|
| Watch Records | Trigger | Reacting when records change. |
| Search Records | Search | Simple lists of records by filter. |
| Search Records (Advanced) | Search | Precise pulls where the plain search is too blunt. |
| Get a Record | Action | Reading one record in full. |
| Make an API Call | Action | An 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.





