web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / Ver. 26.0 throwing an ...
Small and medium business | Business Central, N...
Answered

Ver. 26.0 throwing an error when using "Send to Excel (Only Data)" on a report

(4) ShareShare
ReportReport
Posted on by EGMX 41
Good day, community!
 
Please let me know if this isn't the right forum to post this in. Today, some members of my team ran into an issue that seems to only occur in BC ver. 26.0 (maybe above, too). When we open the reporting options pane for any report, and click Send To > Microsoft Excel Document (data only) > OK, we're greeted with the following nondescript error:
 
 
This is replicable among multiple environments and tenants. I'm unsure how to troubleshoot this, or how we could go about reporting it to Microsoft. Would anyone mind giving me some pointers?
I have the same question (0)
  • Suggested answer
    Sohail Ahmed Profile Picture
    Sohail Ahmed 11,089 Super User 2025 Season 2 on at
    Ver. 26.0 throwing an error when using "Send to Excel (Only Data)" on a report
    Maybe this will help:
     
    Yes, this looks like a known issue in version 26.0 affecting the "Send to Excel (Data Only)" option. It’s likely due to internal changes in how layouts or report rendering is handled.
     
    Quick Suggestions:
     
    Try using "Microsoft Excel Document (with layout)" as a temporary workaround.
     
    Test the same report in a lower version (e.g., 25.x) to confirm version-specific behavior.
     
    To report this, raise a support ticket via your Microsoft Partner or through the Microsoft Admin Center.
     
     
    Mark below checkbox to make this answer Verified if it helps you.
     
     
  • Suggested answer
    Ramesh Kumar Profile Picture
    Ramesh Kumar 7,511 Super User 2025 Season 2 on at
    Ver. 26.0 throwing an error when using "Send to Excel (Only Data)" on a report
    It’s not working in my environment either. I’ve just raised a ticket with the Microsoft Business Central team.
     
    I will keep you posted in here.
     
    Thanks
    Ramesh
     
    If this was helpful, please check the "Does this answer your question?" box and mark it as verified.
  • Suggested answer
    Khushbu Rajvi. Profile Picture
    Khushbu Rajvi. 19,160 Super User 2025 Season 2 on at
    Ver. 26.0 throwing an error when using "Send to Excel (Only Data)" on a report
    Its working fine for me. could you please share more details which report you are trying to generate? 
    try it in incognito mode. 
  • Verified answer
    Mansi Soni Profile Picture
    Mansi Soni 8,885 Super User 2025 Season 2 on at
    Ver. 26.0 throwing an error when using "Send to Excel (Only Data)" on a report
    Hello,

    Yes, this is a known issue in Business Central version 26.0 affecting the "Send To > Microsoft Excel Document (data only)" export option. If you haven't reported it yet, please do so via Microsoft support or your partner. Microsoft is aware of the issue and will likely address this shortly.

    Regards,
    Mansi Soni
  • Gerardo Rentería García Profile Picture
    Gerardo Rentería Ga... 23,574 Most Valuable Professional on at
    Ver. 26.0 throwing an error when using "Send to Excel (Only Data)" on a report
    Hi
    That's correct, the bug has been reported on the official Yammer/Viva Engage portal.
    Best
    GR
  • LizHK Profile Picture
    LizHK 187 on at
    Ver. 26.0 throwing an error when using "Send to Excel (Only Data)" on a report
    I have exact same issue. Told colleague to just use other excel format in the meantime. This is for ALL the reports- this V26 has created a lot more issues with us than other upgrades. I've been having web services failing that was working fine before, etc. thanks for reporting this. I was about to write a question about this.
  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 92,831 Super User 2025 Season 2 on at
    Ver. 26.0 throwing an error when using "Send to Excel (Only Data)" on a report
    I tested Ver. 26.1 and found that this problem does not exist. Maybe it is just a problem with 26.0. You can try upgrading to 26.1 as soon as possible.
     
    Thanks.
    ZHU
  • edn Profile Picture
    edn 6 on at
    Ver. 26.0 throwing an error when using "Send to Excel (Only Data)" on a report
    I am also seeing this behavior in 26.1 Can we expect a solution in 26.2? 
  • Suggested answer
    Ben Baxter Profile Picture
    Ben Baxter 6,396 Super User 2025 Season 2 on at
    Ver. 26.0 throwing an error when using "Send to Excel (Only Data)" on a report
    It appears to be an issue with time zones.  Another forum post suggested changing the User's time zone setting to the opposite of what is normal (from -5 to +5, for example).  I had some of our account managers test this and it did allow the report to run.  This is only a Band-Aid, but for a critical report it will hopefully help.
     
    P.S. We tested in 26.1 and found the issue present there as well.  Hopefully Microsoft can get an update pushed out to resolve this.
     
    Best Regards,
    Ben Baxter
    Accent Software Inc
  • Suggested answer
    DC-29051444-0 Profile Picture
    DC-29051444-0 on at
    Ver. 26.0 throwing an error when using "Send to Excel (Only Data)" on a report
    Hi
     
    If it helps anyone I get the error message as above using CST or EST time zones but not when I choose GMT.
     
    I also can't get the debugger to trap the error grrr

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
Rishabh Kanaskar Profile Picture

Rishabh Kanaskar 4,275

#2
Sumit Singh Profile Picture

Sumit Singh 2,677

#3
Nimsara Jayathilaka. Profile Picture

Nimsara Jayathilaka. 2,526

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans