Skip to main content

Notifications

Announcements

Check out the New Agent Creator Community
Announcing new navigation menus and the Engage with the Community forum!
News and Announcements icon
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

(3) ShareShare
ReportReport
Posted on by EGMX 39
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?
  • Suggested answer
    Mansi Soni Profile Picture
    Mansi Soni 3,391 on at
    Ver. 26.0 throwing an error when using "Send to Excel (Only Data)" on a report
    Hello,

    Yes, it's working in version 26.2, Microsoft has resolved it!

    Regards,
    Mansi Soni
  • Suggested answer
    Khushbu Rajvi. Profile Picture
    Khushbu Rajvi. 17,377 Super User 2025 Season 1 on at
    Ver. 26.0 throwing an error when using "Send to Excel (Only Data)" on a report
    bug is resolved in version 26.2
  • LizHK Profile Picture
    LizHK 177 on at
    Ver. 26.0 throwing an error when using "Send to Excel (Only Data)" on a report
    Created support ticket through partner and got response from Microsoft as below.
    ""It is a known issue, and the fix is planned to be released in version 26.2 sometime in June"
     
  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 84,278 Super User 2025 Season 1 on at
    Ver. 26.0 throwing an error when using "Send to Excel (Only Data)" on a report
    Update: 
    Hi, This is a standard bug and has been discussed in the BC Yammer Group.
    Hope the following info helps.
     
    Thanks.
    ZHU
  • 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
  • Suggested answer
    Ben Baxter Profile Picture
    Ben Baxter 5,810 Super User 2025 Season 1 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
  • edn Profile Picture
    edn 4 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
    YUN ZHU Profile Picture
    YUN ZHU 84,278 Super User 2025 Season 1 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
  • LizHK Profile Picture
    LizHK 177 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.
  • Gerardo Rentería García Profile Picture
    Gerardo Rentería Ga... 19,654 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

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

Check out the New Agent Creator Community
Announcing new navigation menus and the Engage with the Community forum!

Quick Links

Jainam Kothari – Community Spotlight

We are honored to recognize Jainam Kothari as our June 2025 Community…

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard >

Last month Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans