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

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics GP (Archived)

Excel Dashboard Reports not working

(0) ShareShare
ReportReport
Posted on by 39

Hello

I am testing a migration from Dynamics GP 2016 R2 to 2018 R2 and have been addressing various issues. One issue I seem to be unable to resolve involves excel Dashboard reports. When opening any of them an error presents stating "We found a problem with some content in "[our company]. Do you want us to try to recover as much as we can?"

When selecting yes it fails to repair and states. 

Removed Part: /xl/queryTables/queryTable2.xml part. (External data range)
Removed Part: /xl/queryTables/queryTable4.xml part. (External data range)
Removed Part: /xl/queryTables/queryTable7.xml part. (External data range)

Additionally the data is not from our company database but is instead from test data. When researching this issue I did find a forum topic reporting similar issues, but it was never resolved. https://community.dynamics.com/gp/f/32/t/293155

Has anyone seen and fixed this issue?

Thanks for your time. 

*This post is locked for comments

I have the same question (0)
  • Maximo Gomez Profile Picture
    39 on at

    Anyone have any advice here?

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

Quick Links

Responsible AI policies

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

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
mtabor Profile Picture

mtabor 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans