is there a solution to this yet ? I have the same problem the entire last week I could work on my file no problem on Friday afternoon (04/06/2021) I saved and logged of for the weekend. When i got back to work on Monday (07/06/2021) there is no why I could access my pbix file. There where no errors in my pbix file and I don't understand how you should fix a problem in a file if you access the dam thing. There is another error with the data source but that isn't the problem. that error occours randomly since I started having this problem. and even when that part of the error is not present I get the exact same result :
Failed to save modifications to the server. Error returned: 'An argument of function 'DATE' has the wrong data type or the result is too large or too small.
An argument of function 'DATE' has the wrong data type or the result is too large or too small.
My Data source is a direct query on an Asure SQL db. which one again didn't have any issues up untill this error.
Here is my stack trace
Feedback Type:
Frown (Error)
Error Message:
Failed to save modifications to the server. Error returned: 'An argument of function 'DATE' has the wrong data type or the result is too large or too small.
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.
A connection could not be made to the data source with the Name of '{"protocol":"tds","address":{"server":"my server name,1433","database":"myDatabaseName"},"authentication":null,"query":null}'.
'.
Stack Trace:
Microsoft.AnalysisServices.OperationException
at Microsoft.AnalysisServices.Tabular.Model.SaveChangesImpl(SaveOptions options)
at Microsoft.PowerBI.Modeler.ModelManager.<SaveChanges>b__234_0()
at Microsoft.PowerBI.Client.Windows.Modeling.Hosting.ModelingTelemetryService.<>c__DisplayClass6_0`1.<RunInActivity>b__0()
at Microsoft.PowerBI.Client.Windows.Modeling.Hosting.ModelingTelemetryService.RunInActivity(ModelingActivityKind activity, Action action)
at Microsoft.PowerBI.Client.Windows.Modeling.Hosting.ModelingTelemetryService.RunInActivity[T](ModelingActivityKind activity, Func`1 action)
at Microsoft.PowerBI.Modeler.ModelManager.SaveChanges(String description)
at Microsoft.PowerBI.Modeler.ModelManager.InternalTransaction.Commit(Boolean recalc)
at Microsoft.PowerBI.Modeling.Engine.Authoring.AsyncModelAuthoringService.ModelAuthoringTransaction.Commit(RecalcBehavior recalcBehavior)
at Microsoft.PowerBI.Client.Windows.ReportPreparer.<>c.<PerformRecalc>b__21_0(IExtendedModelChangeScope scope)
at Microsoft.PowerBI.Modeling.Engine.Authoring.AsyncModelAuthoringService.RunOutOfBandExtendedModelChange(Action`1 extendedModelChange, IDataModel dataModel, IModelManager modelManager, Boolean roleChangesImpactQueries, IRefreshPolicyUpdater refreshPolicyUpdater, Boolean skipDataModelTracing)
at Microsoft.PowerBI.Modeling.Engine.ModelingEngine.RunOutOfBandExtendedModelChange(Action`1 extendedModelChange, IDataModel dataModel, IModelManager modelManager, Boolean roleChangesImpactQueries, IRefreshPolicyUpdater refreshPolicyUpdater)
at Microsoft.PowerBI.Client.Windows.AnalysisServices.AnalysisServicesDatabaseLocal.RunOutOfBandExtendedModelChange(Action`1 extendedModelChange, IRefreshPolicyUpdater refreshPolicyUpdater, Boolean requireASDBToBeUnattached)
at Microsoft.PowerBI.Client.Windows.ReportPreparer.PerformRecalc(Report report, IPowerBIWindowService windowService)
at Microsoft.PowerBI.Client.Windows.ReportPreparer.Prepare(Report report, PackageValidationResult mashupResult, IPowerBIWindowService windowService, String fileName, ILuciaFeatureSwitchProxy luciaFeatureSwitchProxy, Nullable`1 entryPoint, Version pbixFileVersion, Boolean suppressRecalc)
at Microsoft.PowerBI.Client.Windows.Services.PowerBIPackagingService.Open(Stream stream, String streamName, IPowerBIWindowService windowService, Nullable`1 entryPoint, PowerBIPackageOpenOptions options, ReportPreparerResult& prepareResult)
at Microsoft.PowerBI.Client.Windows.Services.FileManager.<LoadFromPbix>d__23.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at Microsoft.PowerBI.Client.Windows.Services.UIBlockingService.<>c__DisplayClass14_0`1.<<BlockUIAndRun>b__0>d.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at Microsoft.PowerBI.Client.Windows.Services.UIBlockingService.WaitOnUIThreadForTaskCompletion[T](Task`1 task)
at Microsoft.PowerBI.Client.Windows.Services.UIBlockingService.BlockUIAndRun[T](Func`1 asyncMethod)
at Microsoft.PowerBI.Client.Windows.Services.FileManager.OpenFile(IPowerBIWindowService windowService, IPbixFile fileToOpen, Nullable`1 entryPoint)
at Microsoft.PowerBI.Client.Program.TryOpenOrCreateReport(IUIHost uiHost, IPowerBIWindowService windowService, IFileManager fileManager, IFileHistoryManager fileHistoryManager, String filePath, FileType fileType, IFileInformationProtectionManager fileInformationProtectionManager)
at Microsoft.PowerBI.Client.Program.<>c__DisplayClass4_0.<Main>b__1()
at Microsoft.PowerBI.Client.Windows.IExceptionHandlerExtensions.<>c__DisplayClass3_0.<HandleExceptionsWithNestedTasks>b__0()
at Microsoft.Mashup.Host.Document.ExceptionHandlerExtensions.HandleExceptions(IExceptionHandler exceptionHandler, Action action)
Stack Trace Message:
Failed to save modifications to the server. Error returned: 'An argument of function 'DATE' has the wrong data type or the result is too large or too small.
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.
A connection could not be made to the data source with the Name of '{"protocol":"tds","address":{"server":"my server name","database":"myDatabaseName"},"authentication":null,"query":null}'.
'.
Invocation Stack Trace:
at Microsoft.Mashup.Host.Document.ExceptionExtensions.GetCurrentInvocationStackTrace()
at Microsoft.Mashup.Client.UI.Shared.StackTraceInfo..ctor(String exceptionStackTrace, String invocationStackTrace, String exceptionMessage)
at Microsoft.PowerBI.Client.Windows.Telemetry.PowerBIUserFeedbackServices.GetStackTraceInfo(Exception e)
at Microsoft.PowerBI.Client.Windows.Telemetry.PowerBIUserFeedbackServices.ReportException(IWindowHandle activeWindow, IUIHost uiHost, FeedbackPackageInfo feedbackPackageInfo, Exception e, Boolean useGDICapture)
at Microsoft.Mashup.Client.UI.Shared.UnexpectedExceptionHandler.<>c__DisplayClass15_0.<HandleException>b__0()
at Microsoft.Mashup.Client.UI.Shared.UnexpectedExceptionHandler.HandleException(Exception e)
at Microsoft.Mashup.Host.Document.ExceptionHandlerExtensions.HandleExceptions(IExceptionHandler exceptionHandler, Action action)
at Microsoft.PowerBI.Client.Program.Main(String[] args)
PowerBINonFatalError:
{"AppName":"PBIDesktop","AppVersion":"2.93.981.0","ModuleName":"Microsoft.PowerBI.Tabular.dll","Component":"Microsoft.AnalysisServices.Tabular.Model","Error":"Microsoft.AnalysisServices.OperationException","MethodDef":"SaveChangesImpl - PFE_XL_EXCEL_NUM,PFE_SERVERBASE_OPERATION_CANCELLED_BECAUSE_OTHER_ONE_FAILED,PFE_HRE_CONNECTION_FAILED_NO_ID","ErrorOffset":"415"}
PowerBINonFatalError_MethodDefDescription:
PFE_XL_EXCEL_NUM,PFE_SERVERBASE_OPERATION_CANCELLED_BECAUSE_OTHER_ONE_FAILED,PFE_HRE_CONNECTION_FAILED_NO_ID
ModelChangeResult:
{"changes":[]}
PowerBIUserFeedbackServices_IsReported:
True
