locked
Cannot connect to an analysis cube from power query RRS feed

  • Question

  • Hi there,

    I tried searching this forum but could not find related threads. When I try to connect to an analysis cube within powerquery, I get the following error :

    Unexpected error: Object reference not set to an instance of an object.
    Details:
           at Microsoft.Mashup.Engine1.Library.AnalysisServices.AnalysisServicesService.AnalysisServicesDataReader.get_Item(Int32 i)
       at Microsoft.Mashup.Engine1.Library.AnalysisServices.AnalysisServicesService.AnalysisServicesDataReader.get_Item(String fieldName)
       at Microsoft.Mashup.Engine1.Library.AnalysisServices.AnalysisServicesService.get_IsInTabularMode()
       at Microsoft.Mashup.Engine1.Library.AnalysisServices.AnalysisServicesCubeContextProvider.get_DisplayFolders()
       at Microsoft.Mashup.Engine1.Runtime.NativeFunctionValue1`2.Invoke(Value arg0)
       at Microsoft.Mashup.Engine1.Language.DebugExpression.Execute(Value frame)
       at Microsoft.Mashup.Engine1.Language.FunctionInvocationExpression2.Execute(Value frame)
       at Microsoft.Mashup.Engine1.Language.DebugExpression.Execute(Value frame)
       at Microsoft.Mashup.Engine1.Language.RecordExpression.RuntimeRecordValue.Force(Int32 index)
       at Microsoft.Mashup.Engine1.Language.RecordExpression.RuntimeRecordValue.get_Item(Int32 index)
       at Microsoft.Mashup.Engine1.Runtime.RecordValue.get_Item(String field)
       at Microsoft.Mashup.Engine1.Language.RecordExpression.RuntimeRecordValue.Force(Int32 index)
       at Microsoft.Mashup.Engine1.Language.RecordExpression.RuntimeRecordValue.get_Item(Int32 index)
       at Microsoft.Mashup.Engine1.Runtime.RecordValue.get_Item(Value key)
       at Microsoft.Mashup.Engine1.Runtime.Library.Linker.BindFunctionValue.TypedInvoke(RecordValue environment, Value section, TextValue name)
       at Microsoft.Mashup.Engine1.Runtime.NativeFunctionValue3`4.Invoke(Value arg0, Value arg1, Value arg2)
       at Microsoft.Mashup.Engine1.Language.MembersFunctionValue0.Invoke()
       at Microsoft.Mashup.Engine1.Language.ListExpression.RuntimeListValue.Force(Int32 index)
       at Microsoft.Mashup.Engine1.Language.ListExpression.RuntimeListValue.get_Item(Int32 index)
       at Microsoft.Mashup.Engine1.Runtime.ListValue.get_Item(Value key)
       at Microsoft.Mashup.Engine1.Language.MembersFunctionValue1.Invoke(Value arg0)
       at Microsoft.Mashup.Engine1.Language.RecordExpression.RuntimeRecordValue.Force(Int32 index)
       at Microsoft.Mashup.Engine1.Language.RecordExpression.RuntimeRecordValue.get_Item(Int32 index)
       at Microsoft.Mashup.Engine1.Runtime.RecordValue.get_Item(String field)
       at Microsoft.Mashup.Engine1.Language.FunctionInvocationExpression2.Execute(Value frame)
       at Microsoft.Mashup.Engine1.Language.Expression.ExecuteCondition(Value frame)
       at Microsoft.Mashup.Engine1.Language.DebugExpression.ExecuteCondition(Value frame)
       at Microsoft.Mashup.Engine1.Language.IfExpression.Execute(Value frame)
       at Microsoft.Mashup.Engine1.Language.DebugExpression.Execute(Value frame)
       at Microsoft.Mashup.Engine1.Language.RecordExpression.RuntimeRecordValue.Force(Int32 index)
       at Microsoft.Mashup.Engine1.Language.RecordExpression.RuntimeRecordValue.get_Item(Int32 index)
       at Microsoft.Mashup.Engine1.Runtime.RecordValue.get_Item(String field)
       at Microsoft.Mashup.Engine1.Language.MembersFunctionValue0.Invoke()
       at Microsoft.Mashup.Engine1.Engine.Microsoft.Mashup.Engine.Interface.IEngine.Invoke(IValue function, IValue[] arguments)
       at Microsoft.Mashup.Evaluator.SimpleDocumentEvaluator.BeginGetResult(DocumentEvaluationParameters parameters, Action`1 callback)
       at Microsoft.Mashup.Evaluator.SimpleDocumentEvaluator.BeginGetResult(DocumentEvaluationParameters parameters, Action`1 callback)
       at Microsoft.Mashup.Evaluator.FirewallPartition.BeginGetResult[T](Action`1 callback)
       at Microsoft.Mashup.Evaluator.FirewallDocumentEvaluator.Evaluation`1.OnBufferComplete(Exception exception)
       at Microsoft.Mashup.Evaluator.Firewall.BeginBufferPartitions(Action`1 callback)
       at Microsoft.Mashup.Evaluator.FirewallDocumentEvaluator.BeginGetResultInternal[T](DocumentEvaluationParameters parameters, Action`1 callback)
       at Microsoft.Mashup.Evaluator.RemoteDocumentEvaluator.Service.OnBeginGetPreviewValueSource(IMessageContext context, BeginGetPreviewValueSourceMessage message)
       at Microsoft.Mashup.Evaluator.MessageHandlers.TryDispatch(IMessageContext context, Message message)
       at Microsoft.Mashup.Evaluator.ContextMessenger.ContextMessageHandlers.TryDispatch(IMessageContext context, Message message)
       at Microsoft.Mashup.Evaluator.MessageHandlers.Dispatch(IMessageContext context, Message message)
       at Microsoft.Mashup.Evaluator.ContextMessenger.OnMessageWithUnknownContext(IMessageContext baseContext, MessageWithUnknownContext messageWithUnknownContext)
       at Microsoft.Mashup.Evaluator.MessageHandlers.TryDispatch(IMessageContext context, Message message)
       at Microsoft.Mashup.Evaluator.ContextMessenger.ContextMessageHandlers.TryDispatch(IMessageContext context, Message message)
       at Microsoft.Mashup.Evaluator.MessageHandlers.Dispatch(IMessageContext context, Message message)
       at Microsoft.Mashup.Evaluator.EvaluationHost.Run()
       at Microsoft.Mashup.Host.EvaluationContainer.EvaluationContainerMain.Run(String[] args)
       at Microsoft.Mashup.Host.EvaluationContainer.EvaluationContainerMain.Main(String[] args)
       --- End of inner exception stack trace ---
       at Microsoft.Mashup.Evaluator.RemoteDocumentEvaluator.Service.OnBeginGetPreviewValueSource(IMessageContext context, BeginGetPreviewValueSourceMessage message)
       --- End of inner exception stack trace ---
       at Microsoft.Mashup.Host.Document.Preview.PreviewManager.<>c__DisplayClasse.<StartPreviewEvaluation>b__b(EvaluationResult2`1 result)

    Has anyone of you seen this before? Connecting via powerpivot works fine.

    Here is a screenshot :

    Any help would be great


    "all those who believe in psychokenesis, please raise my hand"


    Thursday, February 5, 2015 4:09 PM

Answers

  • This is actually a different bug than what we've seen before. I see what the root cause is and it's still active. We'll have it fixed for the next release.

    In the meantime, there's no workaround, sorry.

    Thursday, February 5, 2015 7:28 PM

All replies

  • I believe we've fixed this for the next version. I don't remember exactly what triggers it, but I don't think you can work around it.
    Thursday, February 5, 2015 5:10 PM
  • This is actually a different bug than what we've seen before. I see what the root cause is and it's still active. We'll have it fixed for the next release.

    In the meantime, there's no workaround, sorry.

    Thursday, February 5, 2015 7:28 PM
  • Actually, there may be a workaround, but it would on the service side. I'll ask around and get back to you soon.

    In the meantime, some questions:

    - What version of SQL Server are you using?
    - Can you access other models on this server?

    Thanks!
    Tristan

    Thursday, February 5, 2015 7:32 PM
  • Thanks for the fast replies guys!

    @Tristan : The server version I am connecting to is 10.0.5852.0, and I cannot access other models on the same server.

    But connecting in a non Analysis Service way works fine. For now I will just access the underlying datawarehouse and wait for the next release.

    Thanks a bunch!


    "all those who believe in psychokenesis, please raise my hand"

    Friday, February 6, 2015 8:45 AM