Your monthly P&L report used to finish in seconds. Now it takes five minutes, and your finance team sits idle while Business Central grinds through the data. For controllers running multi-table reports across several companies, this kind of slowdown is not unusual, and it rarely fixes itself.
The causes range from overloaded FlowFields to poorly filtered datasets, and identifying the right one makes the difference between a quick fix and weeks of guesswork. This guide walks you through seven clear steps to diagnose and fix slow Business Central reports.
Exsion365 gives you a faster alternative for multi-table reporting directly in Excel, and we will show you where that fits in the process.
Before you change anything, pinpoint exactly which reports or pages cause the delay. Vague descriptions like "the system is slow" do not help you isolate the problem.
Open a stopwatch (your phone works fine) and time the specific action: opening a report, refreshing a list, or switching records. Write down the report name, the number of seconds it takes, and when it happens.
This baseline lets you measure whether each fix you try actually makes a difference. It also helps you communicate clearly with your BC partner if you need their support later.
Business Central includes a built-in profiler that shows where time is spent during any action. You do not need technical skills to run it.
Go to Help and Support, then Troubleshooting, then Analyze Performance. Click Start, perform the slow action (open the report or refresh the page), and click Stop.
The results split time between the standard Business Central application and any installed extensions. If an extension is responsible for most of the delay, you now know to contact that app's vendor or your BC partner. According to Microsoft's report performance documentation, report telemetry data can also help you identify slow SQL queries and high row counts at scale.
FlowFields are calculated totals (like "Balance" or "Sales This Year") that Business Central recalculates each time you view a record. On a list page showing 50 rows, each FlowField triggers a separate calculation per row.
FactBoxes are the information panels on the right side of a page. Each one pulls additional data every time the page loads. Together, heavy FlowFields and FactBoxes are one of the most common causes of slow pages.
Use Page Inspection (Ctrl + Alt + F1) to see which fields and extensions load on the page. Then use Personalize (the settings cog) to hide FactBoxes and FlowFields you do not actively need. Even removing two heavy FactBoxes can cut seconds off every load.
Reports that pull from many Business Central tables at once are inherently slower. A sales margin report that joins customer entries, item ledger entries, and general ledger data runs significantly more SQL queries than a single-table customer list.
Ask yourself: does this report really need all those tables in one pass? In many cases, consolidating data from several tables is better handled outside the native report engine, in a tool designed for cross-table joins.
If the report complexity is driven by multi-company data, the overhead multiplies further. Each additional company adds a separate data request cycle. Tools like Exsion365 pull data from multiple tables and companies into a single Excel workbook with one click.
Not every slow report is caused by data volume. Sometimes the report's own design is the bottleneck. Reports migrated from older NAV systems often carry row-by-row processing logic that was never optimized for the current platform.
Layout type matters as well. RDL layouts can run slower than Word layouts for document-style reports, especially when rendering PDFs or sending emails. If a particular report runs slowly only when you print or email it, the layout may be the cause.
Review with your partner whether the report uses AL queries or dataset-level filtering. Reports that automate data retrieval at the query level perform significantly better than those looping through thousands of records in code.
One of the fastest fixes for a slow report is simply reducing the amount of data it processes. Many reports scan years of ledger entries when you only need the current period.
Add date filters before running the report. Limit the dataset to the current fiscal year or the last 12 months. If your report includes dimension filters, set them as tightly as possible. This single step can turn a five-minute report into a ten-second report.
You can also create saved views for frequently used filter combinations. A saved view means your team does not have to remember the right filters each time they run the report.
If your multi-table report is still slow after working through steps one through six, the problem may not be fixable inside the native report engine. Business Central's built-in reports are designed for transactional processing, not for the analytical joins that controllers typically need.
Moving those reports to Excel with a direct data connection gives you more control over how data is loaded and formatted. With Exsion365, you build the report once as a reusable template and refresh it with a single click whenever you need updated numbers.
Because Exsion365 connects directly to your Business Central data and respects your existing user permissions, there is no export step and no risk of stale data. Your multi-company P&L or margin report refreshes in seconds rather than minutes.
Report performance usually degrades gradually. As your company posts more transactions, the tables that reports query grow larger. A report that ran well at go-live may be scanning hundreds of thousands of additional rows two years later.
Retention policies and regular data archiving help keep those tables lean. If your environment has never been cleaned up, scheduling a data review with your BC partner can deliver immediate speed improvements.
Extensions add another layer. Each new extension installs event subscribers that fire on common actions. The more extensions you install over time, the more background processing accumulates on every page load and report run.
Yes. The Performance Profiler and Page Inspection tools in Business Central do not require admin rights or technical training. Any user can run them to identify where delays occur.
For the fixes that involve code changes, database indexes, or extension modifications, you will need your BC partner. The key benefit of diagnosing first is that you arrive at that conversation with specific data instead of a general complaint.
Controllers who want to reduce IT dependency in their day-to-day reporting can move their most time-sensitive reports out of the native engine entirely.
By building those reports in Excel, you control the design, filters, and refresh schedule directly, without waiting on anyone else.
When your reporting needs outgrow what Business Central's native engine can deliver quickly, Exsion365 gives you a direct path to faster results. Exsion Reporting connects Excel to your Business Central data in real time, so you can build multi-table, multi-company reports that refresh with one click.
Instead of waiting for a report that joins five tables and three companies, you build a reusable template in Excel and hit Refresh. The data loads in seconds because Exsion pulls only the fields you need, filtered the way you define them.
Your team already knows Excel. There is no new interface to learn, no training program to schedule. Exsion365 respects your Business Central permissions, so every user sees only the data they are authorized to access.
If you are spending more time waiting for reports than analyzing them, contact us for a no-obligation conversation about your specific reporting challenges.
Slow reports are usually caused by heavy FlowFields, unfiltered datasets scanning too many rows, or reports joining multiple tables. Extensions with poorly optimized code can also add processing time to every report run.
Go to Help and Support, select Troubleshooting, then Analyze Performance. Click Start, run the slow report, and click Stop. The profiler shows whether the delay comes from the base application or an installed extension.
Exsion365 moves your multi-table and multi-company reports to Excel with a direct Business Central connection. Reports that take minutes in the native engine refresh in seconds with Exsion, because you control exactly which data fields are loaded.
No. The Performance Profiler and Page Inspection tools are available to standard users. For deeper fixes like index changes or code optimization, your BC partner will need admin access.
Filters reduce the number of rows a report scans. Adding a date filter to limit data to the current fiscal year can reduce processing time from minutes to seconds. Exsion365 lets you define filters at the template level so they apply automatically on every refresh.
For multi-table analytical reports, yes. Business Central's native engine is optimized for transactional documents. Exsion365 connects Excel directly to your BC data and pulls only the columns and rows you specify, which avoids the overhead of full-table scans.