Can not re-open .pbix file - Start date in calendar function can not be later than the end date.

[drjoachim]

When trying to refresh my data set in Power BI I got the following error: Last refresh failed: Wed Aug 03 2016 10:26:43 GMT+0200 (Romance Daylight Time) There was an error when processing the data in the dataset.Hide details Processing error: An argument of function 'DATE' has the wrong data type or the result is too large or too small. The current operation was cancelled because another operation in the transaction failed. Cluster URI: WABI-NORTH-EUROPE-redirect.analysis.windows.net Activity ID: 55a523c9-af3f-48b0-aa7f-d1ddb83cedce Request ID: fce3ec3d-63fa-4db6-db72-69c771797605 Time: 2016-08-03 08:26:43Z When trying to re-open the PBIX file where i created the set & report I get the following Error Message: ----------------------------------------------------- Failed to save modifications to the server. Error returned: 'The start date in Calendar function can not be later than the end date. An argument of function 'DATE' has the wrong data type or the result is too large or too small. 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: 'The start date in Calendar function can not be later than the end date. An argument of function 'DATE' has the wrong data type or the result is too large or too small. 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.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(String filePathToOpen, IWin32Window ownerWindow, 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, ReportUpgradeResult& upgradeResult) at Microsoft.PowerBI.Client.Program.<>c__DisplayClassc.

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.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) ModelChangeResult ..... ModelChangeResultSerializationErrors Error getting value from 'IsSchemaChangeListComplete' on 'Microsoft.PowerBI.Client.Windows.Modeling.ModelChangeResult'. ----------------------------------------------------- Scheduled 3-8-2016 00:39:23 3-8-2016 00:39:42 Completed Scheduled 2-8-2016 15:36:49 2-8-2016 15:37:10 Completed Scheduled 2-8-2016 14:39:25 2-8-2016 14:39:43 Completed Scheduled 2-8-2016 13:36:52 2-8-2016 13:37:11 Completed ----------------------------------------------------- Yesterday everything was fine... Anybody knows what happened? Is there a work-around or did I just lose everything? Kr

[drjoachim]

'Ok, found a work-around: -> change name of Error.pbix to Error.zip -> Overwrite the DataModel File in the Error.zip file with an empty DataModel file (copied from an empty .pbix file) -> change name of Error.zip to Error.pbix => can now open the Error.pbix file => re-add the connections, fix some errors in calculations

[chass]

Joachim, My apologies about he slow response and thanks for circling back w/ the resolution! Chuck