Microsoft Dynamics GP 2016 R2 Financial Dashboard Error

Microsoft Dynamics GPWhen reviewing some dashboards with a client a while ago we encountered an error launching the Financial Dashboard:

Microsoft Excel - We found a problem with some content in 'T16R2 Financial Dashboard.xlsx'. Do you want us to try to recover as much as we can? If you trust the source of this workbook, click Yes.

Microsoft Excel

We found a problem with some content in 'T16R2 Financial Dashboard.xlsx'. Do you want us to try to recover as much as we can? If you trust the source of this workbook, click Yes.

Clicking Yes results in the Repairs window launching and showing the removed parts:

Repairs to 'T16R2 Financial Dashboard.xlsx'

Clicking close, then resulted in another error being displayed:

Microsoft Excel - Incorrect syntax near '@TimeUnit'

Microsoft Excel

Incorrect syntax near '@TimeUnit'

Clicking OK results in another error:

Microsoft Excel - The following data range failed to refresh: TWO BankTransactions Top 5 Checkbook Balances_1 Continue to refresh all?

Microsoft Excel

The following data range failed to refresh: TWO BankTransactions Top 5 Checkbook Balances_1

Continue to refresh all?

Clicking OK produced another error, this time a SQL Server login rather than an Excel one like the previous:

Microsoft SQL Server Login - Connection failed.

Clicking OK opens the SQL Server Login dialog:

After playing around with a few settings, we concluded that the issue was not able to be resolved and logged with Microsoft. This was confirmed as a quality issue (91076) by Microsoft and that it is with the development team for investigation.

What should we write about next?

Your Name (required) -
Your Email (required) -

(Visited 72 times, 1 visits today)

One thought on “Microsoft Dynamics GP 2016 R2 Financial Dashboard Error

Leave a Reply

Your email address will not be published. Required fields are marked *