Small and medium business | Business Central, N...

Issue with Report Generation and Excel Export

(9) Share

Report

Posted on by Sanchith Fernando

Hi,

I’m experiencing an issue when generating reports. The error message shown below appears during the process. I have already tried using different browsers and updating them, and my network connection is stable, but the problem persists. The same issue also occurs when exporting reports to Excel.

Thank you.

Categories:

Dynamics 365 Business Central

I have the same question (13)

All responses (9)

Answers (0)

CT-19110637-0 20 on at

Like (6)

Report

I’ve been experiencing this issue as well, ever since the update that addressed the Personalize and Page Inspection features last week.
I’ve tried switching browsers, clearing the browser cache, signing out, and restarting the environment, but the issue still persists. This has impacted our operations, especially during the end-of-month period when a large volume of documents needs to be printed.

My current version is W1 26.4 (Platform 26.0.39765.0 + Application 26.4.37194.39971).

4 people found this reply helpful.

Was this reply helpful? Yes No
Suggested answer

Valentin Castravet 31,481 Super User 2025 Season 2 on at

Like (4)

Report

There have been a lot of reports from other users with this error so it seems like its a bug with printing reports.

Valentin Castravet
Work: Zander ERP Services
Blog: Dynamics 365 Business Central Insights
LinkedIn: www.linkedin.com/in/valentin-c-0500a247/

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 95,729 Super User 2025 Season 2 on at

Like (3)

Report

I just tested it in my environment and didn't find this problem yet.

Version: W1 26.5 (Platform 26.0.39898.0 + Application 26.5.38752.39969)

I checked for known bugs and there are none at the moment.

Thanks

ZHU

1 people found this reply helpful.

Was this reply helpful? Yes No
Suggested answer

Mohana Yadav 61,005 Super User 2025 Season 2 on at

Like (4)

Report

Microsoft is investigating the issue.

2 people found this reply helpful.

Was this reply helpful? Yes No
Suggested answer

Rishabh Kanaskar 6,150 on at

Like (3)

Report

Hi,

This usually indicates a report or service-side issue in Business Central rather than a browser or network problem.
Steps to troubleshoot:
> Clear the BC client cache (Sign out > clear browser cache > sign in again).
> Check if the report dataset is too large; try filtering or reducing rows.
> Verify that the Excel export service is running and up to date.
> Test the same report in another environment (sandbox or production) to see if it’s environment specific.

> If the issue persists, raise a support ticket with Microsoft including the error message and report name.

Temporarily, exporting smaller datasets or using PDF/Word formats may bypass the Excel issue.

Thanks

Rishabh

1 people found this reply helpful.

Was this reply helpful? Yes No
Suggested answer

Sumit Singh 10,273 on at

Like (2)

Report
Hi Sanchith,

The official Microsoft guidance for this error is in the Troubleshooting Reports documentation. The error “An error occurred while trying to display the report” usually happens during the rendering phase of a report in Business Central. This can affect both preview and export to Excel because both rely on the report dataset and layout.

Root Causes

Corrupted or incompatible report layout (RDLC or Word).

Unsupported fonts or layout elements in RDLC.

Report dataset issues (filters returning no data or invalid data types).

Platform limits (too many rows, timeout).

Permissions missing for Excel export.

Recommended Fixes

Validate the Report Layout

If using a custom RDLC or Word layout, try switching to the built-in layout via Report Layout Selection.

If the built-in layout works, re-import or redesign the custom layout.

Manage Report Layouts

Check Report Dataset

Export the dataset to Excel (data only) or XML from the request page to confirm data is returned.

If the dataset is empty or invalid, adjust filters or fix AL code.

Troubleshoot Reports [1]

Test in Sandbox

Run the same report in a sandbox or with a different user profile to rule out personalization or permission issues.

Check Permissions

Ensure the user has EXPORT REPORT EXCEL and D365 REPORT permission sets.

For On-Premises

Restart the Business Central Server instance and verify that the RDLC rendering components are installed.

Still having issue, please raise a ticket with Microsoft.

Official Docs:

Troubleshooting Reports in Business Central

References
[1] Troubleshooting reports - Business Central | Microsoft Learn
Please mark “Verified” if it helps.

Was this reply helpful? Yes No
Suggested answer

Suresh Kulla 50,245 Super User 2025 Season 2 on at

Like (1)

Report

There are various reasons for the error. Please check link if that is one of the reason also does this is happening for every report or only specific reports

https://www.itaintboring.com/dynamics-crm/failed-to-generate-excel-an-error-occurred/

Was this reply helpful? Yes No
Suggested answer

Nimsara Jayathilaka. 4,836 on at

Like (5)

Report

Hi

It’s a known intermittent issue affecting some tenants recently. Try clearing cache, switching browsers, and using the standard layout. If multiple users are impacted, it’s likely Microsoft-side, and raising a support ticket is recommended

Thanks

Nimsara

Was this reply helpful? Yes No
Suggested answer

Pallavi Phade 4,124 on at

Like (0)

Report

Namaste @Sanchith Fernando

I tried exporting Vendor Trial Balance Report .

Can you export list page to excel , Are you able to export into excel ?

Can you check the Permission assigned to user if everything is working fine

If this helped , Please mark as "Verified"

Regards

Pallavi Phade

Was this reply helpful? Yes No