Forum Discussion

CJ1608's avatar
CJ1608
Icon for Advocate I rankAdvocate I
9 years ago

Close and Restart Power BI Desktop

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 ...
vanessafvg's avatar
vanessafvg
Icon for Community Champion rankCommunity Champion
9 years ago

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

  • CJ1608's avatar
    CJ1608
    Icon for Advocate I rankAdvocate I
    9 years ago

    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's avatar
      vanessafvg
      Icon for Community Champion rankCommunity Champion
      9 years ago

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

      • CJ1608's avatar
        CJ1608
        Icon for Advocate I rankAdvocate I
        9 years ago

        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 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.
           at Microsoft.AnalysisServices.AdomdClient.AdomdUtils.CheckConnectionOpened(AdomdConnection connection)
           at Microsoft.AnalysisServices.AdomdClient.AdomdConnection.GetSchemaDataSet(String schemaName, String schemaNamespace, AdomdRestrictionCollection restrictions, Boolean throwOnInlineErrors, AdomdPropertyCollection requestProperties)
           at Microsoft.AnalysisServices.AdomdClient.AdomdConnection.GetSchemaDataSet(String schemaName, AdomdRestrictionCollection restrictions)
           at Microsoft.PowerBI.Client.Windows.AnalysisServices.AnalysisServicesDatabase.GetSchemaDataSet(String schemaName, Dictionary`2 restrictions)
           at Microsoft.PowerBI.DAXParser.DAXACListPopulater.ServerInformation.LoadReservedWordCache(IModel model)
           at Microsoft.PowerBI.DAXParser.DAXACListPopulater.EnsureServerInformation(IModel model)
           at Microsoft.PowerBI.DAXParser.DAXACListPopulater.PopulateAll(IModel model, DAXMatchObjectSet& matchObjects)
           at Microsoft.PowerBI.DAXParser.DAXParser.BuildContextForMeasure(IModel model, IMeasure measure, Boolean restrictedDirectQuery)
           at Microsoft.PowerBI.Client.Windows.Modeling.DataModelExtensions.BuildContext(IMeasure measure)
           at Microsoft.PowerBI.Client.Windows.HtmlControls.DaxFormulaBarHtmlControlAsync.UpdateFormulaBarContents()
           at Microsoft.PowerBI.Client.Windows.HtmlControls.DaxFormulaBarHtmlControlAsync.SetCalculation(ICalculationObject calculation)
           at Microsoft.PowerBI.Client.Windows.HtmlControls.DaxFormulaBarHtmlControlAsync.ShowCalculation(ICalculationObject calculation)
           at Microsoft.PowerBI.Client.Windows.HtmlControls.DaxFormulaBarHtmlControlAsync.ShowSchemaItem(SchemaItem schemaItem)
           at Microsoft.Practices.Prism.PubSubEvents.EventSubscription`1.<>c__DisplayClass2.<GetExecutionStrategy>b__0(Object[] arguments)
           at Microsoft.Practices.Prism.PubSubEvents.EventBase.InternalPublish(Object[] arguments)
           at Microsoft.PowerBI.Client.Windows.Services.EventAggregationService.<>c__DisplayClassb`2.<PublishInternal>b__a()
           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.<HandleException>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.Windows.Services.SchemaItemActivationService.SetActiveItem(SchemaItem schemaItem, Boolean raiseEventOnChange)
           at Microsoft.PowerBI.Client.Windows.SchemaItemActivationHostService.<>c__DisplayClass2.<SetActiveSchemaItem>b__1()
           at Microsoft.Mashup.Host.Document.SynchronizationContextExtensions.<>c__DisplayClass3.<SendAndMarshalExceptions>b__0(Object null)
           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.ClientShared.WindowManager.ShowDialog[T](T form, IWin32Window owner)
           at Microsoft.PowerBI.Client.Program.<>c__DisplayClassd.<Main>b__0()
           at Microsoft.Mashup.Host.Document.ExceptionHandlerExtensions.HandleExceptions(IExceptionHandler exceptionHandler, Action action)
           at Microsoft.PowerBI.Client.Program.Main(String[] args)