Close and Restart Power BI Desktop

Question

This bug has been around for a few months now. I reported it with 'send a frown' (twice) but it's still persisting.

If I remember rightly it coincided with the use of 'Quick Measures' when they were first released. However I've recently found that using TREATAS({}) has triggered it too.

One of my desktop files is completely stuck in this state and I began having the same problem in another after having a break waiting for the June update (in the hope there was a fix...) as mentioned when trying to use TREATAS.

The entire model seems to become inaccessable; you can't view any of the tables (they all become empty), refreshing brings back a server connection error and you can't view any of the measure/calculated column formulas.

Even DAX Studio doesn't detect a model schema and you cannot connect this way at all.

I'm afraid the issue seems to be persisting and as I don't know what's causing it I can't avoid/work around it!

It's causing a lot of disruption to our development and management aren't entirely convinced to begin with.

Surely can't be the only person to have experienced this?

vanessafvg · Answer

CJ1608&nbsp;as a work around maybe rewrite the measures without quick measures? &nbsp;

cj1608 · Answer

I haven't used them since and still getting the issue. Even with them turned off.

As I said, even TREATAS() triggered it recently. I've had it happen for other reasons but I can't remember the exact details anymore.

vanessafvg · Answer

CJ1608&nbsp;have you got enough memory? &nbsp;need more information to understand, have you looked in the diagnostic logs? &nbsp;i.e options and settings /&nbsp;options &nbsp;/ diagnostics / enable tracing

cj1608 · Answer

Memory isn't the issue, I've had the system performance window open to check.I've looked at the logs, I might as well be reading ancient greek.When I open the file that is currently ruined and try to click on&nbsp;a measure in the field list this is the trace coming from 'copy details' (it seems to be the most descriptive trace covering the data model):Error Message:The connection is not open.Stack Trace:Microsoft.AnalysisServices.AdomdClient.AdomdConnectionException: The connection is not open.&nbsp;&nbsp; at Microsoft.AnalysisServices.AdomdClient.AdomdUtils.CheckConnectionOpened(AdomdConnection connection)&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, AdomdRestrictionCollection restrictions)&nbsp;&nbsp; at Microsoft.PowerBI.Client.Windows.AnalysisServices.AnalysisServicesDatabase.GetSchemaDataSet(String schemaName, Dictionary`2 restrictions)&nbsp;&nbsp; at Microsoft.PowerBI.DAXParser.DAXACListPopulater.ServerInformation.LoadReservedWordCache(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.BuildContextForMeasure(IModel model, IMeasure measure, Boolean restrictedDirectQuery)&nbsp;&nbsp; at Microsoft.PowerBI.Client.Windows.Modeling.DataModelExtensions.BuildContext(IMeasure measure)&nbsp;&nbsp; at Microsoft.PowerBI.Client.Windows.HtmlControls.DaxFormulaBarHtmlControlAsync.UpdateFormulaBarContents()&nbsp;&nbsp; at Microsoft.PowerBI.Client.Windows.HtmlControls.DaxFormulaBarHtmlControlAsync.SetCalculation(ICalculationObject calculation)&nbsp;&nbsp; at Microsoft.PowerBI.Client.Windows.HtmlControls.DaxFormulaBarHtmlControlAsync.ShowCalculation(ICalculationObject calculation)&nbsp;&nbsp; at Microsoft.PowerBI.Client.Windows.HtmlControls.DaxFormulaBarHtmlControlAsync.ShowSchemaItem(SchemaItem schemaItem)&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__DisplayClassb`2.&lt;PublishInternal&gt;b__a()&nbsp;&nbsp; at Microsoft.Mashup.Host.Document.ExceptionHandlerExtensions.HandleExceptions(IExceptionHandler exceptionHandler, Action action)Invocation Stack Trace:&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.FeedbackErrorInfo..ctor(String message, Nullable`1 errorCode, String requestId, Exception exception)&nbsp;&nbsp; at Microsoft.Mashup.Client.ClientShared.UnexpectedExceptionHandler.&lt;&gt;c__DisplayClass1.&lt;HandleException&gt;b__0()&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 Microsoft.PowerBI.Client.Windows.Services.SchemaItemActivationService.SetActiveItem(SchemaItem schemaItem, Boolean raiseEventOnChange)&nbsp;&nbsp; at Microsoft.PowerBI.Client.Windows.SchemaItemActivationHostService.&lt;&gt;c__DisplayClass2.&lt;SetActiveSchemaItem&gt;b__1()&nbsp;&nbsp; at Microsoft.Mashup.Host.Document.SynchronizationContextExtensions.&lt;&gt;c__DisplayClass3.&lt;SendAndMarshalExceptions&gt;b__0(Object null)&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.PowerBI.Client.Program.&lt;&gt;c__DisplayClassd.&lt;Main&gt;b__0()&nbsp;&nbsp; at Microsoft.Mashup.Host.Document.ExceptionHandlerExtensions.HandleExceptions(IExceptionHandler exceptionHandler, Action action)&nbsp;&nbsp; at Microsoft.PowerBI.Client.Program.Main(String[] args)

vanessafvg · Answer

CJ1608&nbsp;have you tried to log a support ticket with microsoft? &nbsp;also have you updated the latest version?

Forum Discussion

Close and Restart Power BI Desktop

10 Replies

Related content

Closing value

Restart Capacity

Open Mirroring - Replication not restarting for large tables

Gateway Restart Script For Gateway Offline

Latest Closing Balance