Calculated Columns and Measures: The resource string could not be loaded

Question

Hi fellow PowerBI enthusiasts!I was working on my model in PowerBI, but since&nbsp;I've updated to the latest PowerBI (desktop) version, I no longer see the formula's of my Calculated Columns and Measures.&nbsp;They do still perform the calculations, but I cannot see or edit the formula.I recieve the error: "The resource string could not be loaded".I also cannot create any new measures or calculated columns, this results in the same error.Clicking excisting measures/columns sometimes results in Power BI crashing.&nbsp;It only happens with this specific file, but recreating my entire model would take an enourmous amount of time.&nbsp;I would be very thankfull if someone could help me resolve this. If I need to provide more details, please let me know.

ashishrj · Answer

JesperP&nbsp;Can you open the old pbix file and try "Save As" new pbix file and then try if that works!

jesperp · Answer

Thank you for your response ashishrj. I saved the old pbix to a new one. Unfortunately, it didn't work. :smileysad:

jesperp · Answer

Bellow is the detailed error log:Spoiler (Highlight to read)Foutbericht:The resource string cannot be loaded.Stacktracering:Microsoft.AnalysisServices.AdomdClient.AdomdErrorResponseException: The resource string cannot be loaded.&nbsp;&nbsp; at Microsoft.AnalysisServices.AdomdClient.AdomdConnection.XmlaClientProvider.Microsoft.AnalysisServices.AdomdClient.AdomdConnection.IXmlaClientProviderEx.Discover(String requestType, String requestNamespace, IDictionary restrictions, InlineErrorHandlingType inlineErrorHandling, IDictionary requestProperties)&nbsp;&nbsp; at Microsoft.AnalysisServices.AdomdClient.AdomdConnection.GetSchemaDataSet(String schemaName, String schemaNamespace, IDictionary adomdRestrictions, Boolean throwOnInlineErrors, IDictionary requestProperties)&nbsp;&nbsp; at Microsoft.AnalysisServices.AdomdClient.AdomdConnection.GetSchemaDataSet(String schemaName, String schemaNamespace, AdomdRestrictionCollection restrictions, Boolean throwOnInlineErrors, AdomdPropertyCollection requestProperties)&nbsp;&nbsp; at Microsoft.AnalysisServices.AdomdClient.AdomdConnection.GetSchemaDataSet(String schemaName, String schemaNamespace, AdomdRestrictionCollection restrictions, Boolean throwOnInlineErrors)&nbsp;&nbsp; at Microsoft.AnalysisServices.AdomdClient.AdomdConnection.GetSchemaDataSet(String schemaName, AdomdRestrictionCollection restrictions)&nbsp;&nbsp; at Microsoft.PowerBI.DAXParser.DAXACListPopulater.ServerInformation.LoadFunctionsWithRestrictions(AdomdRestrictionCollection restrictions, IModel model)&nbsp;&nbsp; at Microsoft.PowerBI.DAXParser.DAXACListPopulater.ServerInformation.LoadFunctionCache(IModel model)&nbsp;&nbsp; at Microsoft.PowerBI.DAXParser.DAXACListPopulater.EnsureServerInformation(IModel model)&nbsp;&nbsp; at Microsoft.PowerBI.DAXParser.DAXACListPopulater.PopulateAll(IModel model, DAXMatchObjectSet&amp; matchObjects)&nbsp;&nbsp; at Microsoft.PowerBI.DAXParser.DAXParser.BuildContextForColumn(IModel model, IColumn column)&nbsp;&nbsp; at Microsoft.PowerBI.Modeler.ModelManager.BuildContextForCalcColumn(CalculatedColumn tomCalcColumn)&nbsp;&nbsp; at Microsoft.PowerBI.Client.Windows.DaxFormulaBarHtmlControl.UpdateFormulaBarContents()&nbsp;&nbsp; at Microsoft.PowerBI.Client.Windows.DaxFormulaBarHtmlControl.OnModelChanged(ModelChangedEventArgs e)&nbsp;&nbsp; at Microsoft.Practices.Prism.PubSubEvents.EventSubscription`1.&lt;&gt;c__DisplayClass2.&lt;GetExecutionStrategy&gt;b__0(Object[] arguments)&nbsp;&nbsp; at Microsoft.Practices.Prism.PubSubEvents.EventBase.InternalPublish(Object[] arguments)&nbsp;&nbsp; at Microsoft.PowerBI.Client.Windows.Services.EventAggregationService.&lt;&gt;c__DisplayClass4`2.&lt;PublishInteral&gt;b__3(Object state)&nbsp;&nbsp; at Microsoft.Mashup.Host.Document.ExceptionHandlerExtensions.HandleExceptions(IExceptionHandler exceptionHandler, Action action)Aanroep stacktracering:&nbsp;&nbsp; at Microsoft.Mashup.Host.Document.ExceptionExtensions.GetCurrentInvocationStackTrace()&nbsp;&nbsp; at Microsoft.Mashup.Client.ClientShared.StackTraceInfo..ctor(String exceptionStackTrace, String invocationStackTrace)&nbsp;&nbsp; at Microsoft.Mashup.Client.ClientShared.UnexpectedExceptionHandler.&lt;&gt;c__DisplayClass1.&lt;HandleException&gt;b__0()&nbsp;&nbsp; at Microsoft.Mashup.Host.Document.SynchronizationContextExtensions.Send(SynchronizationContext context, IExceptionHandler exceptionHandler, Action callback)&nbsp;&nbsp; at Microsoft.Mashup.Client.ClientShared.UnexpectedExceptionHandler.HandleException(Exception e)&nbsp;&nbsp; at Microsoft.Mashup.Host.Document.ExceptionHandlerExtensions.HandleExceptions(IExceptionHandler exceptionHandler, Action action)&nbsp;&nbsp; at System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor)&nbsp;&nbsp; at System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments)&nbsp;&nbsp; at System.Delegate.DynamicInvokeImpl(Object[] args)&nbsp;&nbsp; at System.Windows.Forms.Control.InvokeMarshaledCallbackDo(ThreadMethodEntry tme)&nbsp;&nbsp; at System.Windows.Forms.Control.InvokeMarshaledCallbackHelper(Object obj)&nbsp;&nbsp; at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)&nbsp;&nbsp; at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)&nbsp;&nbsp; at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)&nbsp;&nbsp; at System.Windows.Forms.Control.InvokeMarshaledCallback(ThreadMethodEntry tme)&nbsp;&nbsp; at System.Windows.Forms.Control.InvokeMarshaledCallbacks()&nbsp;&nbsp; at System.Windows.Forms.Control.WndProc(Message&amp; m)&nbsp;&nbsp; at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)&nbsp;&nbsp; at System.Windows.Forms.UnsafeNativeMethods.DispatchMessageW(MSG&amp; msg)&nbsp;&nbsp; at System.Windows.Forms.UnsafeNativeMethods.DispatchMessageW(MSG&amp; msg)&nbsp;&nbsp; at System.Windows.Forms.Application.ComponentManager.System.Windows.Forms.UnsafeNativeMethods.IMsoComponentManager.FPushMessageLoop(IntPtr dwComponentID, Int32 reason, Int32 pvLoopData)&nbsp;&nbsp; at System.Windows.Forms.Application.ThreadContext.RunMessageLoopInner(Int32 reason, ApplicationContext context)&nbsp;&nbsp; at System.Windows.Forms.Application.ThreadContext.RunMessageLoop(Int32 reason, ApplicationContext context)&nbsp;&nbsp; at System.Windows.Forms.Form.ShowDialog(IWin32Window owner)&nbsp;&nbsp; at Microsoft.Mashup.Client.ClientShared.WindowManager.ShowDialog[T](T form, IWin32Window owner)&nbsp;&nbsp; at Microsoft.Mashup.Client.ClientShared.Ux.FloatingDialog.SimpleDialog.StatusDialog.ShowStatusDialog(IWin32Window owner, Action cancelCallback, Nullable`1 showTimeout)&nbsp;&nbsp; at Microsoft.PowerBI.Client.Windows.Services.ShellService.ShowStatusDialog(LocalizedString message, Action cancelCallback, Nullable`1 showDelay)&nbsp;&nbsp; at Microsoft.PowerBI.Client.Windows.Utilities.TaskUtilities.RunAsyncAndBlockUI(Task task)&nbsp;&nbsp; at Microsoft.PowerBI.Client.Windows.Modeling.CalculationEditor.Microsoft.PowerBI.Client.Windows.Modeling.ICalculationEditor.UpdateCalculation(UpdateCalculationRouteRequiredSchemaChange schemaChange)&nbsp;&nbsp; at Microsoft.PowerBI.Client.Windows.SchemaChangeRoutingVisitor.Route(ModelChange modelChange, Boolean runAsync)&nbsp;&nbsp; at Microsoft.PowerBI.Client.Windows.DaxFormulaBarHtmlControl.CommitChanges()&nbsp;&nbsp; at Microsoft.PowerBI.Client.Windows.DaxFormulaBarHtmlControl.CommitOrDeletePendingCalculation()&nbsp;&nbsp; at Microsoft.PowerBI.Client.Windows.DaxFormulaBarHtmlControl.TrySaveChanges(Boolean closing)&nbsp;&nbsp; at Microsoft.Mashup.Client.ClientShared.Controls.HtmlControl.TrySaveChanges(Boolean closing)&nbsp;&nbsp; at Microsoft.Mashup.Client.ClientShared.Controls.HtmlControl.TrySaveChanges(Boolean closing)&nbsp;&nbsp; at Microsoft.Mashup.Client.ClientShared.Controls.HtmlControl.TrySaveChanges(Boolean closing)&nbsp;&nbsp; at Microsoft.Mashup.Client.ClientShared.Controls.HtmlControl.TrySaveChanges(Boolean closing)&nbsp;&nbsp; at Microsoft.Mashup.Client.ClientShared.Controls.HtmlControl.TrySaveChanges(Boolean closing)&nbsp;&nbsp; at Microsoft.PowerBI.Client.Windows.EditorDialog.TryCommitPendingUIEdits(Boolean closing)&nbsp;&nbsp; at Microsoft.Mashup.Client.Windows.Ribbon.CommandManager.ExecutePreCommandActions(UInt32 commandId)&nbsp;&nbsp; at Microsoft.Mashup.Client.Windows.Ribbon.RibbonCommandHandler.Execute(UInt32 commandId, CommandExecutionVerb verb, PropertyKeyRef keyRef, PropVariantRef currentValue, IUISimplePropertySet commandExecutionProperties)&nbsp;&nbsp; at System.Windows.Forms.UnsafeNativeMethods.DispatchMessageW(MSG&amp; msg)&nbsp;&nbsp; at System.Windows.Forms.UnsafeNativeMethods.DispatchMessageW(MSG&amp; msg)&nbsp;&nbsp; at System.Windows.Forms.Application.ComponentManager.System.Windows.Forms.UnsafeNativeMethods.IMsoComponentManager.FPushMessageLoop(IntPtr dwComponentID, Int32 reason, Int32 pvLoopData)&nbsp;&nbsp; at System.Windows.Forms.Application.ThreadContext.RunMessageLoopInner(Int32 reason, ApplicationContext context)&nbsp;&nbsp; at System.Windows.Forms.Application.ThreadContext.RunMessageLoop(Int32 reason, ApplicationContext context)&nbsp;&nbsp; at System.Windows.Forms.Form.ShowDialog(IWin32Window owner)&nbsp;&nbsp; at Microsoft.Mashup.Client.ClientShared.WindowManager.ShowDialog[T](T form, IWin32Window owner)&nbsp;&nbsp; at Microsoft.PowerBI.Client.Program.&lt;&gt;c__DisplayClass8.&lt;Main&gt;b__1()&nbsp;&nbsp; at Microsoft.Mashup.Host.Document.ExceptionHandlerExtensions.HandleExceptions(IExceptionHandler exceptionHandler, Action action)&nbsp;&nbsp; at Microsoft.PowerBI.Client.Program.Main(String[] args)&nbsp;Foutbericht:The resource string cannot be loaded.Stacktracering:Microsoft.AnalysisServices.AdomdClient.AdomdErrorResponseException: The resource string cannot be loaded.&nbsp;&nbsp; at Microsoft.AnalysisServices.AdomdClient.AdomdConnection.XmlaClientProvider.Microsoft.AnalysisServices.AdomdClient.AdomdConnection.IXmlaClientProviderEx.Discover(String requestType, String requestNamespace, IDictionary restrictions, InlineErrorHandlingType inlineErrorHandling, IDictionary requestProperties)&nbsp;&nbsp; at Microsoft.AnalysisServices.AdomdClient.AdomdConnection.GetSchemaDataSet(String schemaName, String schemaNamespace, IDictionary adomdRestrictions, Boolean throwOnInlineErrors, IDictionary requestProperties)&nbsp;&nbsp; at Microsoft.AnalysisServices.AdomdClient.AdomdConnection.GetSchemaDataSet(String schemaName, String schemaNamespace, AdomdRestrictionCollection restrictions, Boolean throwOnInlineErrors, AdomdPropertyCollection requestProperties)&nbsp;&nbsp; at Microsoft.AnalysisServices.AdomdClient.AdomdConnection.GetSchemaDataSet(String schemaName, String schemaNamespace, AdomdRestrictionCollection restrictions, Boolean throwOnInlineErrors)&nbsp;&nbsp; at Microsoft.AnalysisServices.AdomdClient.AdomdConnection.GetSchemaDataSet(String schemaName, AdomdRestrictionCollection restrictions)&nbsp;&nbsp; at Microsoft.PowerBI.DAXParser.DAXACListPopulater.ServerInformation.LoadFunctionsWithRestrictions(AdomdRestrictionCollection restrictions, IModel model)&nbsp;&nbsp; at Microsoft.PowerBI.DAXParser.DAXACListPopulater.ServerInformation.LoadFunctionCache(IModel model)&nbsp;&nbsp; at Microsoft.PowerBI.DAXParser.DAXACListPopulater.EnsureServerInformation(IModel model)&nbsp;&nbsp; at Microsoft.PowerBI.DAXParser.DAXACListPopulater.PopulateAll(IModel model, DAXMatchObjectSet&amp; matchObjects)&nbsp;&nbsp; at Microsoft.PowerBI.DAXParser.DAXParser.BuildContextForColumn(IModel model, IColumn column)&nbsp;&nbsp; at Microsoft.PowerBI.Modeler.ModelManager.BuildContextForCalcColumn(CalculatedColumn tomCalcColumn)&nbsp;&nbsp; at Microsoft.PowerBI.Client.Windows.DaxFormulaBarHtmlControl.UpdateFormulaBarContents()&nbsp;&nbsp; at Microsoft.PowerBI.Client.Windows.DaxFormulaBarHtmlControl.OnModelChanged(ModelChangedEventArgs e)&nbsp;&nbsp; at Microsoft.Practices.Prism.PubSubEvents.EventSubscription`1.&lt;&gt;c__DisplayClass2.&lt;GetExecutionStrategy&gt;b__0(Object[] arguments)&nbsp;&nbsp; at Microsoft.Practices.Prism.PubSubEvents.EventBase.InternalPublish(Object[] arguments)&nbsp;&nbsp; at Microsoft.PowerBI.Client.Windows.Services.EventAggregationService.&lt;&gt;c__DisplayClass4`2.&lt;PublishInteral&gt;b__3(Object state)&nbsp;&nbsp; at Microsoft.Mashup.Host.Document.ExceptionHandlerExtensions.HandleExceptions(IExceptionHandler exceptionHandler, Action action)Aanroep stacktracering:&nbsp;&nbsp; at Microsoft.Mashup.Host.Document.ExceptionExtensions.GetCurrentInvocationStackTrace()&nbsp;&nbsp; at Microsoft.Mashup.Client.ClientShared.StackTraceInfo..ctor(String exceptionStackTrace, String invocationStackTrace)&nbsp;&nbsp; at Microsoft.Mashup.Client.ClientShared.UnexpectedExceptionHandler.&lt;&gt;c__DisplayClass1.&lt;HandleException&gt;b__0()&nbsp;&nbsp; at Microsoft.Mashup.Host.Document.SynchronizationContextExtensions.Send(SynchronizationContext context, IExceptionHandler exceptionHandler, Action callback)&nbsp;&nbsp; at Microsoft.Mashup.Client.ClientShared.UnexpectedExceptionHandler.HandleException(Exception e)&nbsp;&nbsp; at Microsoft.Mashup.Host.Document.ExceptionHandlerExtensions.HandleExceptions(IExceptionHandler exceptionHandler, Action action)&nbsp;&nbsp; at System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor)&nbsp;&nbsp; at System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments)&nbsp;&nbsp; at System.Delegate.DynamicInvokeImpl(Object[] args)&nbsp;&nbsp; at System.Windows.Forms.Control.InvokeMarshaledCallbackDo(ThreadMethodEntry tme)&nbsp;&nbsp; at System.Windows.Forms.Control.InvokeMarshaledCallbackHelper(Object obj)&nbsp;&nbsp; at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)&nbsp;&nbsp; at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)&nbsp;&nbsp; at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)&nbsp;&nbsp; at System.Windows.Forms.Control.InvokeMarshaledCallback(ThreadMethodEntry tme)&nbsp;&nbsp; at System.Windows.Forms.Control.InvokeMarshaledCallbacks()&nbsp;&nbsp; at System.Windows.Forms.Control.WndProc(Message&amp; m)&nbsp;&nbsp; at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)&nbsp;&nbsp; at System.Windows.Forms.UnsafeNativeMethods.DispatchMessageW(MSG&amp; msg)&nbsp;&nbsp; at System.Windows.Forms.UnsafeNativeMethods.DispatchMessageW(MSG&amp; msg)&nbsp;&nbsp; at System.Windows.Forms.Application.ComponentManager.System.Windows.Forms.UnsafeNativeMethods.IMsoComponentManager.FPushMessageLoop(IntPtr dwComponentID, Int32 reason, Int32 pvLoopData)&nbsp;&nbsp; at System.Windows.Forms.Application.ThreadContext.RunMessageLoopInner(Int32 reason, ApplicationContext context)&nbsp;&nbsp; at System.Windows.Forms.Application.ThreadContext.RunMessageLoop(Int32 reason, ApplicationContext context)&nbsp;&nbsp; at System.Windows.Forms.Form.ShowDialog(IWin32Window owner)&nbsp;&nbsp; at Microsoft.Mashup.Client.ClientShared.WindowManager.ShowDialog[T](T form, IWin32Window owner)&nbsp;&nbsp; at Microsoft.Mashup.Client.ClientShared.Ux.FloatingDialog.SimpleDialog.StatusDialog.ShowStatusDialog(IWin32Window owner, Action cancelCallback, Nullable`1 showTimeout)&nbsp;&nbsp; at Microsoft.PowerBI.Client.Windows.Services.ShellService.ShowStatusDialog(LocalizedString message, Action cancelCallback, Nullable`1 showDelay)&nbsp;&nbsp; at Microsoft.PowerBI.Client.Windows.Utilities.TaskUtilities.RunAsyncAndBlockUI(Task task)&nbsp;&nbsp; at Microsoft.PowerBI.Client.Windows.Modeling.CalculationEditor.Microsoft.PowerBI.Client.Windows.Modeling.ICalculationEditor.UpdateCalculation(UpdateCalculationRouteRequiredSchemaChange schemaChange)&nbsp;&nbsp; at Microsoft.PowerBI.Client.Windows.SchemaChangeRoutingVisitor.Route(ModelChange modelChange, Boolean runAsync)&nbsp;&nbsp; at Microsoft.PowerBI.Client.Windows.DaxFormulaBarHtmlControl.CommitChanges()&nbsp;&nbsp; at Microsoft.PowerBI.Client.Windows.DaxFormulaBarHtmlControl.CommitOrDeletePendingCalculation()&nbsp;&nbsp; at Microsoft.PowerBI.Client.Windows.DaxFormulaBarHtmlControl.TrySaveChanges(Boolean closing)&nbsp;&nbsp; at Microsoft.Mashup.Client.ClientShared.Controls.HtmlControl.TrySaveChanges(Boolean closing)&nbsp;&nbsp; at Microsoft.Mashup.Client.ClientShared.Controls.HtmlControl.TrySaveChanges(Boolean closing)&nbsp;&nbsp; at Microsoft.Mashup.Client.ClientShared.Controls.HtmlControl.TrySaveChanges(Boolean closing)&nbsp;&nbsp; at Microsoft.Mashup.Client.ClientShared.Controls.HtmlControl.TrySaveChanges(Boolean closing)&nbsp;&nbsp; at Microsoft.Mashup.Client.ClientShared.Controls.HtmlControl.TrySaveChanges(Boolean closing)&nbsp;&nbsp; at Microsoft.PowerBI.Client.Windows.EditorDialog.TryCommitPendingUIEdits(Boolean closing)&nbsp;&nbsp; at Microsoft.Mashup.Client.Windows.Ribbon.CommandManager.ExecutePreCommandActions(UInt32 commandId)&nbsp;&nbsp; at Microsoft.Mashup.Client.Windows.Ribbon.RibbonCommandHandler.Execute(UInt32 commandId, CommandExecutionVerb verb, PropertyKeyRef keyRef, PropVariantRef currentValue, IUISimplePropertySet commandExecutionProperties)&nbsp;&nbsp; at System.Windows.Forms.UnsafeNativeMethods.DispatchMessageW(MSG&amp; msg)&nbsp;&nbsp; at System.Windows.Forms.UnsafeNativeMethods.DispatchMessageW(MSG&amp; msg)&nbsp;&nbsp; at System.Windows.Forms.Application.ComponentManager.System.Windows.Forms.UnsafeNativeMethods.IMsoComponentManager.FPushMessageLoop(IntPtr dwComponentID, Int32 reason, Int32 pvLoopData)&nbsp;&nbsp; at System.Windows.Forms.Application.ThreadContext.RunMessageLoopInner(Int32 reason, ApplicationContext context)&nbsp;&nbsp; at System.Windows.Forms.Application.ThreadContext.RunMessageLoop(Int32 reason, ApplicationContext context)&nbsp;&nbsp; at System.Windows.Forms.Form.ShowDialog(IWin32Window owner)&nbsp;&nbsp; at Microsoft.Mashup.Client.ClientShared.WindowManager.ShowDialog[T](T form, IWin32Window owner)&nbsp;&nbsp; at Microsoft.PowerBI.Client.Program.&lt;&gt;c__DisplayClass8.&lt;Main&gt;b__1()&nbsp;&nbsp; at Microsoft.Mashup.Host.Document.ExceptionHandlerExtensions.HandleExceptions(IExceptionHandler exceptionHandler, Action action)&nbsp;&nbsp; at Microsoft.PowerBI.Client.Program.Main(String[] args)&nbsp;

konstantinos · Answer

Probably the model is sort of corrupted..This is a wild guess but if you change the extension from pbix to zip you will be able to see a folder called model...try to copy that to a new fresh pbix file which you have also turn into zip...then convert back to pbix..I am not sure I this is possible with the visuals also..

jesperp · Answer

Hi konstantinos, The model does not include all the data needed to rebuild the file, but it gave me the opertunity to actually 'see' the calculations, so that I can now recreate them in a new file, so thanks for your advice!

Forum Discussion

Calculated Columns and Measures: The resource string could not be loaded

5 Replies

Related content

DAX Calculated Measure

Less resource consumption

DAX Measure for Ranking the valid rows and calculating the average rating

Measure or Calculated Column

Azure resource graph and KQL