Forum Discussion
Can't open report
Hi,
With our Financial Year over, I've come to open a PowerBI Report to modify it. When opening, it gives me the following error:
"Failed to save modifications to the server. Error returned: 'In DATEDIFF function, the start date cannot be greater than the end date
The current operation was cancelled because another operation in the transaction failed."
Has anyone had this problem before? - And if so how can I open it?
Thanks!
(Bug report below).
Feedback Type:
Frown (Error)
Timestamp:
2017-04-03T16:23:26.0082629Z
Local Time:
2017-04-03T17:23:26.0082629+01:00
Product Version:
2.44.4675.521 (PBIDesktop) (x64)
Release:
March 2017
IE Version:
11.953.14393.0
OS Version:
Microsoft Windows NT 10.0.14393.0 (x64 en-GB)
CLR Version:
4.6.2. or later [Release Number = 394802]
Peak Working Set:
314 MB
Private Memory:
257 MB
Peak Virtual Memory:
33.4 GB
Error Message:
Failed to save modifications to the server. Error returned: 'In DATEDIFF function, the start date cannot be greater than the end date
The current operation was cancelled because another operation in the transaction failed.
'.
Stack Trace:
Microsoft.AnalysisServices.OperationException: Failed to save modifications to the server. Error returned: 'In DATEDIFF function, the start date cannot be greater than the end date
The current operation was cancelled because another operation in the transaction failed.
'.
at Microsoft.AnalysisServices.Tabular.Model.SaveChanges(SaveOptions saveOptions)
at Microsoft.PowerBI.Modeler.ModelManager.InternalTransaction.Commit()
at Microsoft.PowerBI.Client.Windows.Modeling.AsyncModelAuthoringService.ModelAuthoringTransaction.<Commit>b__15()
at Microsoft.PowerBI.Client.Windows.Modeling.ModelAuthoringExceptionHandler.AddModelChangeResultToExceptions(Action action, ModelChangeResult modelChangeResult)
at Microsoft.PowerBI.Client.Windows.Modeling.AsyncModelAuthoringService.ModelAuthoringTransaction.Commit()
at Microsoft.PowerBI.Client.Windows.ReportUpgrader.Upgrade(Report report)
at Microsoft.PowerBI.Client.Windows.Report.Upgrade()
at Microsoft.PowerBI.Client.Windows.Services.FileManager.OpenFile(IASLiveConnectionPropertiesValidator validator, String filePathToOpen, ReportUpgradeResult& upgradeResult)
at Microsoft.PowerBI.Client.Program.TryOpenOrCreateReport(WindowsHost windowsHost, ISplashScreen splashScreen, IFileManager fileManager, IFileHistoryManager fileHistoryManager, IPowerBIStringProvider stringProvider, String filePath, PBIWinLoadPBIAppAction loadEvent, Report& report, String& importFromExcelFilePath, String& templateFilePath, String& autoRecoveredFilePath, ReportUpgradeResult& upgradeResult)
at Microsoft.PowerBI.Client.Program.<>c__DisplayClassb.<Main>b__0()
at Microsoft.Mashup.Host.Document.ExceptionHandlerExtensions.HandleExceptions(IExceptionHandler exceptionHandler, Action action)
Invocation Stack Trace:
at Microsoft.Mashup.Host.Document.ExceptionExtensions.GetCurrentInvocationStackTrace()
at Microsoft.Mashup.Client.ClientShared.StackTraceInfo..ctor(String exceptionStackTrace, String invocationStackTrace)
at Microsoft.Mashup.Client.ClientShared.FeedbackErrorInfo..ctor(String message, Nullable`1 errorCode, String requestId, Exception exception)
at Microsoft.Mashup.Client.ClientShared.UnexpectedExceptionHandler.<>c__DisplayClass1.<HandleException>b__0()
at Microsoft.Mashup.Client.ClientShared.UnexpectedExceptionHandler.HandleException(Exception e)
at Microsoft.Mashup.Host.Document.ExceptionHandlerExtensions.HandleExceptions(IExceptionHandler exceptionHandler, Action action)
at Microsoft.PowerBI.Client.Program.Main(String[] args)
User ID:
************************************
Session ID:
************************************
Telemetry Enabled:
True