Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |