When 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.
Clicking Yes results in the Repairs window launching and showing the removed parts:
Clicking close, then resulted in another error being displayed:
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?
Clicking OK produced another error, this time a SQL Server login rather than an Excel one like the previous:
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?
If there is a topic which fits the typical ones of this site, which you would like to see me write about, please use the form, below, to submit your idea.
Any solution for this issue? we are almost May of 2019 and I have the same issue.
No, I’ve not seen a fix for this problem.