cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
jameslo30 Member
Member

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