Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
jnie
Regular Visitor

Disable auto date time

When trying to disable auto date time I get an error 

Here are the details that were saved to the clip board. (as much as I can fit)

Feedback Type:
Frown (Error)

Error Message:
An item with the same key has already been added.

Stack Trace:
Microsoft.Mashup.Host.Document.JavaScriptException
at ModernButtonViewModel.prototype.onClick (ms-pbi://pbi.microsoft.com/ts/Shared/Form/ModernButtonViewModel.js:38:9)
at click (Function code:2:31)
at click (ms-pbi://pbi.microsoft.com/ts/Shared/Button.js:190:46)
at Anonymous function (ms-pbi://pbi.microsoft.com/ts/Shared/Button.js:27:21)
at n.event.dispatch (ms-pbi://pbi.microsoft.com/opensource/jquery/jquery-2.2.4.js:3:7481)
at r.handle (ms-pbi://pbi.microsoft.com/opensource/jquery/jquery-2.2.4.js:3:5547)

Microsoft.Mashup.Client.UI.Shared.JavaScriptInvocationException
at Microsoft.Mashup.Client.UI.Windows.JsErrorHandler.WrapInvokeScript(Func`1 invokeScript)
at Microsoft.Mashup.Client.UI.Shared.Com.ComJsObject.Invoke[T](String methodName, Object[] args)
at Microsoft.Mashup.Client.UI.Shared.Com.ComJsObject.TryInvoke[T](String methodName, Object[] args, T& result)
at Microsoft.Mashup.Client.UI.Shared.IJsObjectExtensions.TryInvoke(IJsObject jsObject, String methodName, Object[] args)
at Microsoft.Mashup.Client.UI.Shared.Ux.FloatingDialog.SimpleDialog.OptionsDialogBase.OnDefaultButton()
at Microsoft.Mashup.Client.UI.Shared.Models.ModernButton.OnClick(String parameters)
at Microsoft.Mashup.Client.UI.Shared.Ux.FloatingDialog.KoFloatingDialog.OnButtonClick(String groupName, String name)

Microsoft.Mashup.Host.Document.JavaScriptException
at Anonymous function (ms-pbi://pbi.microsoft.com/ts/FloatingDialog/SimpleDialog/KoOptionsDialog.js:25:102)
at Anonymous function (ms-pbi://pbi.microsoft.com/opensource/jquery/jquery-2.2.4.js:2:28458)
at i (ms-pbi://pbi.microsoft.com/opensource/jquery/jquery-2.2.4.js:2:27146)
at j.add (ms-pbi://pbi.microsoft.com/opensource/jquery/jquery-2.2.4.js:2:27263)
at Anonymous function (ms-pbi://pbi.microsoft.com/opensource/jquery/jquery-2.2.4.js:2:28439)
at each (ms-pbi://pbi.microsoft.com/opensource/jquery/jquery-2.2.4.js:2:2856)
at Anonymous function (ms-pbi://pbi.microsoft.com/opensource/jquery/jquery-2.2.4.js:2:28385)
at Deferred (ms-pbi://pbi.microsoft.com/opensource/jquery/jquery-2.2.4.js:2:28720)
at d.then (ms-pbi://pbi.microsoft.com/opensource/jquery/jquery-2.2.4.js:2:28355)
at GroupTabControl.prototype.tryCommitAndClose (ms-pbi://pbi.microsoft.com/ts/GroupTabControl.js:44:13)

System.ArgumentException
at System.ThrowHelper.ThrowArgumentException(ExceptionResource resource)
at System.Collections.Generic.Dictionary`2.Insert(TKey key, TValue value, Boolean add)
at Microsoft.PowerBI.PersistentCache.DiskPersistentCache.PersistentDictionary.<>c__DisplayClass10_0.<ReadBucket>b__0()
at Microsoft.PowerBI.PersistentCache.FileSystemAccessHelper.<>c__DisplayClass3_0.<IgnoringAccessExceptions>b__0()
at Microsoft.PowerBI.PersistentCache.FileSystemAccessHelper.TryIgnoringAccessExceptions[T](Func`1 func, IEvaluationConstants evaluationConstants, T& result, Exception& accessException)
at Microsoft.PowerBI.PersistentCache.FileSystemAccessHelper.IgnoringAccessExceptions(Action action, IEvaluationConstants evaluationConstants)
at Microsoft.PowerBI.PersistentCache.DiskPersistentCache.PersistentDictionary.TryGetKeyValues(Dictionary`2& dictionary)
at Microsoft.PowerBI.PersistentCache.DiskPersistentCache._DeleteFiles()
at Microsoft.PowerBI.PersistentCache.DiskPersistentCache.DeleteFiles()
at Microsoft.PowerBI.PersistentCache.DiskPersistentCache.Purge()
at Microsoft.PowerBI.Client.Windows.Services.LuciaCacheService.set_MaxCacheSize(Int64 value)
at Microsoft.PowerBI.Client.Windows.HtmlControls.Options.DataLoadPaneHtmlControl.CommitViewModel()
at Microsoft.Mashup.Client.UI.Shared.HtmlControls.TabControl.TabPaneContainerHtmlControl.Commit()
at Microsoft.Mashup.Client.UI.Shared.Ux.FloatingDialog.SimpleDialog.OptionsDialogBase.CommitAndClose()
at Microsoft.PowerBI.Client.Windows.FloatingDialog.OptionsDialog.CommitAndClose()

Stack Trace Message:
An item with the same key has already been added.

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__DisplayClass14_0.<HandleException>b__0()
at Microsoft.Mashup.Client.UI.Shared.UnexpectedExceptionHandler.HandleException(Exception e)
at Microsoft.Mashup.Client.UI.Shared.Ux.FloatingDialog.FloatingDialog.OnError(String message, String stackTrace)
at System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor)
at System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments)
at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)
at Microsoft.Mashup.Client.UI.Shared.JsExportWrapper.<>c__DisplayClass13_0.<InvokeMember>b__0()
at Microsoft.Mashup.Client.UI.Windows.JsErrorHandler.WrapInvokeHost(Func`1 invokeHost)
at System.Windows.Forms.UnsafeNativeMethods.DispatchMessageW(MSG& msg)
at System.Windows.Forms.UnsafeNativeMethods.DispatchMessageW(MSG& msg)
at System.Windows.Forms.Application.ComponentManager.System.Windows.Forms.UnsafeNativeMethods.IMsoComponentManager.FPushMessageLoop(IntPtr dwComponentID, Int32 reason, Int32 pvLoopData)
at System.Windows.Forms.Application.ThreadContext.RunMessageLoopInner(Int32 reason, ApplicationContext context)
at System.Windows.Forms.Application.ThreadContext.RunMessageLoop(Int32 reason, ApplicationContext context)
at System.Windows.Forms.Form.ShowDialog(IWin32Window owner)
at Microsoft.Mashup.Client.UI.Windows.DialogWindowBase.ShowModal(IWindowHandle windowHandle)
at Microsoft.Mashup.Client.UI.Shared.WebDialogs.WebDialog.<>n__0(IWindowHandle owner)
at Microsoft.Mashup.Client.UI.Shared.WindowManager.ShowModal[T](T dialog, Func`1 showModalFunction)
at Microsoft.PowerBI.Client.Windows.Services.PowerBIWindowService.<>c__DisplayClass10_0.<Microsoft.Mashup.Client.UI.Shared.Ux.IWindowService.ShowDialog>b__0()
at Microsoft.PowerBI.Client.Windows.Services.PowerBIWindowService.Trace[T](String action, String title, String details, Func`1 showDialog, Func`2 getResult)
at Microsoft.PowerBI.Client.Windows.Services.PowerBIWindowService.Trace(String action, String title, String details, Func`1 showDialog)
at Microsoft.PowerBI.Client.Windows.Services.PowerBIWindowService.Microsoft.Mashup.Client.UI.Shared.Ux.IWindowService.ShowDialog(IDialog dialog)
at Microsoft.PowerBI.Client.Windows.MainWindow.Microsoft.PowerBI.Client.Windows.Services.IApplication.ShowMachineSettingsDialog()
at Microsoft.PowerBI.Client.Windows.FileMenuHostService.ManageSettings(String id)
at Microsoft.PowerBI.Client.Windows.FileMenuHostService.HandleMenuItem(String tabId, String id)
at System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor)
at System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments)
at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)
at Microsoft.PowerBI.Client.Windows.HostServiceDispatcher.<>c__DisplayClass15_0.<ExecuteInteropCsMethod>b__0()
at Microsoft.PowerBI.Client.Windows.HostServiceDispatcher.<>c__DisplayClass16_0`1.<RunAsync>b__0(Object s)
at System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor)
at System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments)
at System.Delegate.DynamicInvokeImpl(Object[] args)
at System.Windows.Forms.Control.InvokeMarshaledCallbackDo(ThreadMethodEntry tme)
at System.Windows.Forms.Control.InvokeMarshaledCallbackHelper(Object obj)
at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
at System.Windows.Forms.Control.InvokeMarshaledCallback(ThreadMethodEntry tme)
at System.Windows.Forms.Control.InvokeMarshaledCallbacks()
at System.Windows.Forms.Control.WndProc(Message& m)
at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
at System.Windows.Forms.UnsafeNativeMethods.DispatchMessageW(MSG& msg)
at System.Windows.Forms.UnsafeNativeMethods.DispatchMessageW(MSG& msg)
at System.Windows.Forms.Application.ComponentManager.System.Windows.Forms.UnsafeNativeMethods.IMsoComponentManager.FPushMessageLoop(IntPtr dwComponentID, Int32 reason, Int32 pvLoopData)
at System.Windows.Forms.Application.ThreadContext.RunMessageLoopInner(Int32 reason, ApplicationContext context)
at System.Windows.Forms.Application.ThreadContext.RunMessageLoop(Int32 reason, ApplicationContext context)
at System.Windows.Forms.Form.ShowDialog(IWin32Window owner)
at Microsoft.Mashup.Client.UI.Shared.WindowManager.ShowModal[T](T dialog, Func`1 showModalFunction)
at Microsoft.PowerBI.Client.Program.<>c__DisplayClass7_0.<RunApplicationLegacy>b__0()
at Microsoft.PowerBI.Client.Windows.IExceptionHandlerExtensions.<>c__DisplayClass3_0.<HandleExceptionsWithNestedTasks>b__0()
at Microsoft.Mashup.Host.Document.ExceptionHandlerExtensions.HandleExceptions(IExceptionHandler exceptionHandler, Action action)
at Microsoft.PowerBI.Client.Program.RunApplicationLegacy(String[] args)
at Microsoft.PowerBI.Client.Program.Main(String[] args)


PowerBINonFatalError:
{"AppName":"PBIDesktop","AppVersion":"2.130.930.0","ModuleName":"Microsoft.PowerBI.PersistentCache.dll","Component":"Microsoft.PowerBI.PersistentCache.DiskPersistentCache+PersistentDictionary+<>c__DisplayClass10_0","Error":"System.ArgumentException","MethodDef":"<ReadBucket>b__0","ErrorOffset":"63","ErrorCode":""}

InnerException0.Stack Trace Message:
An item with the same key has already been added.

InnerException0.Stack Trace:
at Microsoft.Mashup.Client.UI.Windows.JsErrorHandler.WrapInvokeScript(Func`1 invokeScript)
at Microsoft.Mashup.Client.UI.Shared.Com.ComJsObject.Invoke[T](String methodName, Object[] args)
at Microsoft.Mashup.Client.UI.Shared.Com.ComJsObject.TryInvoke[T](String methodName, Object[] args, T& result)
at Microsoft.Mashup.Client.UI.Shared.IJsObjectExtensions.TryInvoke(IJsObject jsObject, String methodName, Object[] args)
at Microsoft.Mashup.Client.UI.Shared.Ux.FloatingDialog.SimpleDialog.OptionsDialogBase.OnDefaultButton()
at Microsoft.Mashup.Client.UI.Shared.Models.ModernButton.OnClick(String parameters)
at Microsoft.Mashup.Client.UI.Shared.Ux.FloatingDialog.KoFloatingDialog.OnButtonClick(String groupName, String name)

InnerException0.Invocation Stack Trace:
at Microsoft.Mashup.Host.Document.ExceptionExtensions.GetCurrentInvocationStackTrace()
at Microsoft.Mashup.Client.UI.Shared.FeedbackErrorInfo.GetFeedbackValuesFromException(Exception e, String prefix)
at Microsoft.Mashup.Client.UI.Shared.FeedbackErrorInfo.GetFeedbackValuesFromInnerExceptions(Exception e, Int32 depth)
at Microsoft.Mashup.Client.UI.Shared.FeedbackErrorInfo.CreateAdditionalErrorInfo(Exception e)
at Microsoft.Mashup.Client.UI.Shared.FeedbackErrorInfo..ctor(String message, Exception exception, Nullable`1 stackTraceInfo, String messageDetail)
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__DisplayClass14_0.<HandleException>b__0()
at Microsoft.Mashup.Client.UI.Shared.UnexpectedExceptionHandler.HandleException(Exception e)
at Microsoft.Mashup.Client.UI.Shared.Ux.FloatingDialog.FloatingDialog.OnError(String message, String stackTrace)
at System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor)
at System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments)
at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)
at Microsoft.Mashup.Client.UI.Shared.JsExportWrapper.<>c__DisplayClass13_0.<InvokeMember>b__0()
at Microsoft.Mashup.Client.UI.Windows.JsErrorHandler.WrapInvokeHost(Func`1 invokeHost)
at System.Windows.Forms.UnsafeNativeMethods.DispatchMessageW(MSG& msg)
at System.Windows.Forms.UnsafeNativeMethods.DispatchMessageW(MSG& msg)
at System.Windows.Forms.Application.ComponentManager.System.Windows.Forms.UnsafeNativeMethods.IMsoComponentManager.FPushMessageLoop(IntPtr dwComponentID, Int32 reason, Int32 pvLoopData)
at System.Windows.Forms.Application.ThreadContext.RunMessageLoopInner(Int32 reason, ApplicationContext context)
at System.Windows.Forms.Application.ThreadContext.RunMessageLoop(Int32 reason, ApplicationContext context)
at System.Windows.Forms.Form.ShowDialog(IWin32Window owner)
at Microsoft.Mashup.Client.UI.Windows.DialogWindowBase.ShowModal(IWindowHandle windowHandle)
at Microsoft.Mashup.Client.UI.Shared.WebDialogs.WebDialog.<>n__0(IWindowHandle owner)
at Microsoft.Mashup.Client.UI.Shared.WindowManager.ShowModal[T](T dialog, Func`1 showModalFunction)
at Microsoft.PowerBI.Client.Windows.Services.PowerBIWindowService.<>c__DisplayClass10_0.<Microsoft.Mashup.Client.UI.Shared.Ux.IWindowService.ShowDialog>b__0()
at Microsoft.PowerBI.Client.Windows.Services.PowerBIWindowService.Trace[T](String action, String title, String details, Func`1 showDialog, Func`2 getResult)
at Microsoft.PowerBI.Client.Windows.Services.PowerBIWindowService.Trace(String action, String title, String details, Func`1 showDialog)
at Microsoft.PowerBI.Client.Windows.Services.PowerBIWindowService.Microsoft.Mashup.Client.UI.Shared.Ux.IWindowService.ShowDialog(IDialog dialog)
at Microsoft.PowerBI.Client.Windows.MainWindow.Microsoft.PowerBI.Client.Windows.Services.IApplication.ShowMachineSettingsDialog()
at Microsoft.PowerBI.Client.Windows.FileMenuHostService.ManageSettings(String id)
at Microsoft.PowerBI.Client.Windows.FileMenuHostService.HandleMenuItem(String tabId, String id)
at System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor)
at System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments)
at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)
at Microsoft.PowerBI.Client.Windows.HostServiceDispatcher.<>c__DisplayClass15_0.<ExecuteInteropCsMethod>b__0()
at Microsoft.PowerBI.Client.Windows.HostServiceDispatcher.<>c__DisplayClass16_0`1.<RunAsync>b__0(Object s)
at System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor)
at System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments)
at System.Delegate.DynamicInvokeImpl(Object[] args)
at System.Windows.Forms.Control.InvokeMarshaledCallbackDo(ThreadMethodEntry tme)
at System.Windows.Forms.Control.InvokeMarshaledCallbackHelper(Object obj)
at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
at System.Windows.Forms.Control.InvokeMarshaledCallback(ThreadMethodEntry tme)
at System.Windows.Forms.Control.InvokeMarshaledCallbacks()
at System.Windows.Forms.Control.WndProc(Message& m)
at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
at System.Windows.Forms.UnsafeNativeMethods.DispatchMessageW(MSG& msg)
at System.Windows.Forms.UnsafeNativeMethods.DispatchMessageW(MSG& msg)
at System.Windows.Forms.Application.ComponentManager.System.Windows.Forms.UnsafeNativeMethods.IMsoComponentManager.FPushMessageLoop(IntPtr dwComponentID, Int32 reason, Int32 pvLoopData)
at System.Windows.Forms.Application.ThreadContext.RunMessageLoopInner(Int32 reason, ApplicationContext context)
at System.Windows.Forms.Application.ThreadContext.RunMessageLoop(Int32 reason, ApplicationContext context)
at System.Windows.Forms.Form.ShowDialog(IWin32Window owner)
at Microsoft.Mashup.Client.UI.Shared.WindowManager.ShowModal[T](T dialog, Func`1 showModalFunction)
at Microsoft.PowerBI.Client.Program.<>c__DisplayClass7_0.<RunApplicationLegacy>b__0()
at Microsoft.PowerBI.Client.Windows.IExceptionHandlerExtensions.<>c__DisplayClass3_0.<HandleExceptionsWithNestedTasks>b__0()
at Microsoft.Mashup.Host.Document.ExceptionHandlerExtensions.HandleExceptions(IExceptionHandler exceptionHandler, Action action)
at Microsoft.PowerBI.Client.Program.RunApplicationLegacy(String[] args)
at Microsoft.PowerBI.Client.Program.Main(String[] args)



 

7 REPLIES 7
jnie
Regular Visitor

@Ritaf1983  Thanks for the sugjestion and I thought that might be it too, but when I open a new blank BI report and try to toggle the setting it get the same error.   Any thoughts on why that would be?  

Hi @jnie 
Try to clear the cache :

Ritaf1983_0-1720633680484.png

If it will not help, 
try to uninstall and reinstall Power BI desktop

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.

 

even uninstalling and re installing i get the same

Ritaf1983
Super User
Super User

Hi @jnie 
It seems that you used some columns of the result of the automatically created hierarchy columns as a keys for the relationship between the tables of the model.
you can see all the relationships from the "Manage relationship" window:

Ritaf1983_0-1720237742850.png

find the relationship by columns like Day, year, month, etc...remove them, and then disable auto date time.

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.

@Ritaf1983 Right, but I think that is not the issue.  At this point, I have no data and no relationships and I still get that.  

jnie_0-1720633999048.png

 

Hi @jnie 
My new response isn't related to some model...

Ritaf1983_0-1720634275976.png

 

jnie_0-1720643048405.png

same outcome after clearing the cache that 

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.