Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

OData error calling function

Hi,   I would like to get help from you guys, I have a problem trying to get data from a OData source. The data comes from a OData function and it receives a JSON as a parameter, in Power BI that ...
Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    Anonymous,

    Could you please re-create a function which has same features as executeQuery3 in Power BI Desktop ? Based on your original error message, there are some methods inside executeQuery3 function are not supported in Power BI Desktop.

    Regards,
    Lydia

  • Anonymous's avatar
    Anonymous
    7 years ago

    Yes, the result is as expected. So, I will use my own function. Thanks for your help.

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Anonymous,

Do you get expected result when creating your own function in Power BI Desktop? Based on my understanding, the function is an out-of-box function in OData service, as long as you can get same result using your own function, there is no difference between them.

Regards,
Lydia

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Yes, the result is as expected. So, I will use my own function. Thanks for your help.

  • xhirvana's avatar
    xhirvana
    Regular Visitor
    3 years ago

    Hi! I hope to seek help regarding OData URL Error. There is this one Odata URL that we use for our Business Central (On Premises) as data source for creating our reports, it is working fine the past weeks, however last week the reports in our power bi services connected to it suddenly stopped and showing below error. Whether we run it in Power BI Services or desktop, the same error shows. Can you please advice, what ca be done on this?  Those reports that were connected to our SQL Server works fine though. Error only happens for those which were connected to our OData URL.Thank you.

     

    Unexpected error: Specified method is not supported.
    Details:
    Microsoft.Mashup.Evaluator.Interface.ErrorException: Specified method is not supported. --->  Microsoft.Mashup.Evaluator.Interface.ErrorException: Specified method is not supported. ---> System.NotSupportedException: Specified method is not supported. ---> System.NotSupportedException: Specified method is not supported.
    at Microsoft.Mashup.Engine1.Library.OData.V4.ODataExpression.VisitColumnAccess(ColumnAccessQueryExpression expression)
    at Microsoft.Mashup.Engine1.Library.OData.V4.ODataColumns..ctor(RecordTypeValue recordTypeValue, Capabilities capability, IEdmEntityType entityType, ODataEnvironment environment)
    at Microsoft.Mashup.Engine1.Library.OData.V4.ODataQuery..ctor(ODataEnvironment environment, IEdmNavigationSource navigationSource, ODataPath path, IEdmNamedElement namedElement, IEdmEntityType entityType, RecordTypeValue recordTypeValue, Boolean isComposable, Boolean allColumnsSelected, Uri baseUri)
    at Microsoft.Mashup.Engine1.Library.OData.V4.ODataQuery..ctor(ODataEnvironment environment, IEdmEntitySet entitySet, RecordTypeValue recordTypeValue)
    at Microsoft.Mashup.Engine1.Library.OData.V4.ODataEnvironment.BuildTableForTableValueKind(String tableName, TypeValue typeValue)
    at Microsoft.Mashup.Engine1.Library.OData.ODataEnvironmentBase.CreateCatalogTableValue(IEngineHost host)
    at Microsoft.Mashup.Engine1.Library.OData.V4.ODataResponse.CreateValueFromPayload(ODataEnvironment environment, Uri uri, HttpResponseData responseData, ODataJsonLightContextUriParseResult parseResult)
    at Microsoft.Mashup.Engine1.Library.OData.V4.ODataResponse.Create(Uri requestUri, HttpResponseData responseData, HttpResource resource, Value headers, ResourceCredentialCollection credentials, IEngineHost host, ODataSettings settings, ODataUserSettings userSettings)
    at Microsoft.Mashup.Engine1.Library.OData.ODataModule.GetFeed(HttpResource resource, TextValue serviceUriValue, TextValue uriValue, Value headers, IEngineHost host, ResourceCredentialCollection credentials, ODataSettingsBase settings, ODataUserSettings userSettings, Boolean useCachedCredentials)
    at Microsoft.Mashup.Engine1.Library.OData.ODataModule.FeedFunctionValue.TypedInvoke(TextValue serviceUri, Value headers, Value options)
    at Microsoft.Mashup.Engine1.Runtime.NativeFunctionValue3`4.Invoke(Value arg0, Value arg1, Value arg2)
    at Microsoft.Mashup.Engine1.Language.DebugInstruction.Execute(MembersFrame1& frame)
    at Microsoft.Mashup.Engine1.Language.InstructionInvocationInstruction1.Execute(MembersFrame1& frame)
    at Microsoft.Mashup.Engine1.Language.TryCatchInstruction.Execute(MembersFrame1& frame)
    at Microsoft.Mashup.Engine1.Language.DebugInstruction.Execute(MembersFrame1& frame)
    at Microsoft.Mashup.Engine1.Language.MembersFunctionValue1.Invoke(Value arg0)
    at Microsoft.Mashup.Engine1.Language.RecordInstruction.RuntimeRecordValue.Force(Int32 index)
    at Microsoft.Mashup.Engine1.Language.RecordInstruction.RuntimeRecordValue.get_Item(Int32 index)
    at Microsoft.Mashup.Engine1.Language.MembersFunctionValue1.Invoke(Value arg0)
    at Microsoft.Mashup.Engine1.Language.RecordInstruction.RuntimeRecordValue.Force(Int32 index)
    at Microsoft.Mashup.Engine1.Language.RecordInstruction.RuntimeRecordValue.get_Item(Int32 index)
    at Microsoft.Mashup.Engine1.Language.FieldAccessInstruction.Execute(Value frame)
    at Microsoft.Mashup.Engine1.Language.DebugInstruction.Execute(Value frame)
    at Microsoft.Mashup.Engine1.Language.EqualsInstruction.ExecuteCondition(Value frame)
    at Microsoft.Mashup.Engine1.Language.DebugInstruction.ExecuteCondition(Value frame)
    at Microsoft.Mashup.Engine1.Language.IfInstruction.Execute(Value frame)
    at Microsoft.Mashup.Engine1.Language.DebugInstruction.Execute(Value frame)
    at Microsoft.Mashup.Engine1.Language.RecordInstruction.RuntimeRecordValue.Force(Int32 index)
    at Microsoft.Mashup.Engine1.Language.RecordInstruction.RuntimeRecordValue.get_Item(Int32 index)
    at Microsoft.Mashup.Engine1.Language.RuntimeFunctionValueN.Invoke(Value[] args)
    at Microsoft.Mashup.Engine1.Language.FunctionInvocationInstruction2.Execute(MembersFrameN& frame)
    at Microsoft.Mashup.Engine1.Language.RuntimeFunctionValueN.Invoke(Value[] args)
    at Microsoft.Mashup.Engine1.Language.DebugInstruction.Execute(MembersFrame1& frame)
    at Microsoft.Mashup.Engine1.Language.MembersFunctionValue1.Invoke(Value arg0)
    at Microsoft.Mashup.Engine1.Language.RecordInstruction.RuntimeRecordValue.Force(Int32 index)
    at Microsoft.Mashup.Engine1.Language.RecordInstruction.RuntimeRecordValue.get_Item(Int32 index)
    at Microsoft.Mashup.Engine1.Language.InstructionInvocationInstruction2.Execute(MembersFrame1& frame)
    at Microsoft.Mashup.Engine1.Language.DebugInstruction.Execute(MembersFrame1& frame)
    at Microsoft.Mashup.Engine1.Language.MembersFunctionValue1.Invoke(Value arg0)
    at Microsoft.Mashup.Engine1.Language.RecordInstruction.RuntimeRecordValue.Force(Int32 index)
    at Microsoft.Mashup.Engine1.Language.RecordInstruction.RuntimeRecordValue.get_Item(Int32 index)
    at Microsoft.Mashup.Engine1.Language.MembersFunctionValue2.Invoke(Value arg0, Value arg1)
    at Microsoft.Mashup.Engine1.Language.FunctionInvocationInstruction2.Execute(MembersFrame2& frame)
    at Microsoft.Mashup.Engine1.Language.MembersFunctionValue2.Invoke(Value arg0, Value arg1)
    at Microsoft.Mashup.Engine1.Language.DebugInstruction.Execute(MembersFrame1& frame)
    at Microsoft.Mashup.Engine1.Language.MembersFunctionValue1.Invoke(Value arg0)
    at Microsoft.Mashup.Engine1.Language.MembersFunctionValue0.Invoke()
    at Microsoft.Mashup.Engine1.Language.ListInstruction.RuntimeListValue.Force(Int32 index)
    at Microsoft.Mashup.Engine1.Language.ListInstruction.RuntimeListValue.get_Item(Int32 index)
    at Microsoft.Mashup.Engine1.Runtime.ElementAccessValueReference.get_Value()
    at Microsoft.Mashup.Engine1.Runtime.RecordValue.ReferenceArrayRecordValue.get_Item(Int32 index)
    at Microsoft.Mashup.Engine1.Language.DebugInstruction.Execute(MembersFrame1& frame)
    at Microsoft.Mashup.Engine1.Language.InstructionInvocationInstruction2.Execute(MembersFrame1& frame)
    at Microsoft.Mashup.Engine1.Language.DebugInstruction.Execute(MembersFrame1& frame)
    at Microsoft.Mashup.Engine1.Language.MembersFunctionValue1.Invoke(Value arg0)
    at Microsoft.Mashup.Engine1.Language.RecordInstruction.RuntimeRecordValue.Force(Int32 index)
    at Microsoft.Mashup.Engine1.Language.RecordInstruction.RuntimeRecordValue.get_Item(Int32 index)
    at Microsoft.Mashup.Engine1.Language.FunctionInvocationInstruction2.Execute(MembersFrame1& frame)
    at Microsoft.Mashup.Engine1.Language.DebugInstruction.Execute(MembersFrame1& frame)
    at Microsoft.Mashup.Engine1.Language.FieldAccessInstruction.Execute(MembersFrame1& frame)
    at Microsoft.Mashup.Engine1.Language.DebugInstruction.Execute(MembersFrame1& frame)
    at Microsoft.Mashup.Engine1.Language.InstructionInvocationInstruction2.Execute(MembersFrame1& frame)
    at Microsoft.Mashup.Engine1.Language.DebugInstruction.Execute(MembersFrame1& frame)
    at Microsoft.Mashup.Engine1.Language.MembersFunctionValue1.Invoke(Value arg0)
    at Microsoft.Mashup.Engine1.Language.RecordInstruction.RuntimeRecordValue.Force(Int32 index)
    at Microsoft.Mashup.Engine1.Language.RecordInstruction.RuntimeRecordValue.get_Item(Int32 index)
    at Microsoft.Mashup.Engine1.Language.InstructionInvocationInstruction2.Execute(MembersFrame1& frame)
    at Microsoft.Mashup.Engine1.Language.DebugInstruction.Execute(MembersFrame1& frame)
    at Microsoft.Mashup.Engine1.Language.FunctionInvocationInstruction2.Execute(MembersFrame1& frame)
    at Microsoft.Mashup.Engine1.Language.DebugInstruction.Execute(MembersFrame1& frame)
    at Microsoft.Mashup.Engine1.Language.InstructionInvocationInstruction2.Execute(MembersFrame1& frame)
    at Microsoft.Mashup.Engine1.Language.DebugInstruction.Execute(MembersFrame1& frame)
    at Microsoft.Mashup.Engine1.Language.MembersFunctionValue1.Invoke(Value arg0)
    at Microsoft.Mashup.Engine1.Language.RecordInstruction.RuntimeRecordValue.Force(Int32 index)
    at Microsoft.Mashup.Engine1.Language.RecordInstruction.RuntimeRecordValue.get_Item(Int32 index)
    at Microsoft.Mashup.Engine1.Language.MembersFunctionValue1.Invoke(Value arg0)
    at Microsoft.Mashup.Engine1.Language.RecordInstruction.RuntimeRecordValue.Force(Int32 index)
    at Microsoft.Mashup.Engine1.Language.RecordInstruction.RuntimeRecordValue.get_Item(Int32 index)
    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.ListInstruction.RuntimeListValue.Force(Int32 index)
    at Microsoft.Mashup.Engine1.Language.ListInstruction.RuntimeListValue.get_Item(Int32 index)
    at Microsoft.Mashup.Engine1.Language.MembersFunctionValue1.Invoke(Value arg0)
    at Microsoft.Mashup.Engine1.Language.RecordInstruction.RuntimeRecordValue.Force(Int32 index)
    at Microsoft.Mashup.Engine1.Language.RecordInstruction.RuntimeRecordValue.get_Item(Int32 index)
    at Microsoft.Mashup.Engine1.Language.FunctionInvocationInstruction2.Execute(MembersFrame1& frame)
    at Microsoft.Mashup.Engine1.Language.Instruction.ExecuteCondition(MembersFrame1& frame)
    at Microsoft.Mashup.Engine1.Language.DebugInstruction.ExecuteCondition(MembersFrame1& frame)
    at Microsoft.Mashup.Engine1.Language.IfInstruction.Execute(MembersFrame1& frame)
    at Microsoft.Mashup.Engine1.Language.DebugInstruction.Execute(MembersFrame1& frame)
    at Microsoft.Mashup.Engine1.Language.MembersFunctionValue1.Invoke(Value arg0)
    at Microsoft.Mashup.Engine1.Language.RecordInstruction.RuntimeRecordValue.Force(Int32 index)
    at Microsoft.Mashup.Engine1.Language.RecordInstruction.RuntimeRecordValue.get_Item(Int32 index)
    at Microsoft.Mashup.Engine1.Language.MembersFunctionValue0.Invoke()
    at Microsoft.Mashup.Evaluator.SimpleDocumentEvaluator.BeginGetResult(DocumentEvaluationParameters parameters, Action`1 callback)
    --- End of inner exception stack trace ---
    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.Interface.IDocumentEvaluatorExtensions.GetResult[T](IDocumentEvaluator`1 evaluator, DocumentEvaluationParameters parameters)
    at Microsoft.Mashup.Evaluator.RemoteDocumentEvaluator.Service.OnBeginGetResult[T](IMessageChannel channel, BeginGetResultMessage message, Action`1 action)
    at Microsoft.Mashup.Evaluator.RemoteDocumentEvaluator.Service.OnBeginGetPreviewValueSource(IMessageChannel channel, BeginGetPreviewValueSourceMessage message)
    at Microsoft.Mashup.Evaluator.MessageHandlers.TryDispatch(IMessageChannel channel, Message message)
    at Microsoft.Mashup.Evaluator.ChannelMessenger.ChannelMessageHandlers.TryDispatch(IMessageChannel channel, Message message)
    at Microsoft.Mashup.Evaluator.MessageHandlers.Dispatch(IMessageChannel channel, Message message)
    at Microsoft.Mashup.Evaluator.ChannelMessenger.OnMessageWithUnknownChannel(IMessageChannel baseChannel, MessageWithUnknownChannel messageWithUnknownChannel)
    at Microsoft.Mashup.Evaluator.MessageHandlers.TryDispatch(IMessageChannel channel, Message message)
    at Microsoft.Mashup.Evaluator.ChannelMessenger.ChannelMessageHandlers.TryDispatch(IMessageChannel channel, Message message)
    at Microsoft.Mashup.Evaluator.MessageHandlers.Dispatch(IMessageChannel channel, Message message)
    at Microsoft.Mashup.Evaluator.EvaluationHost.Run()
    at Microsoft.Mashup.Container.EvaluationContainerMain.Run(Object args)
    at Microsoft.Mashup.Evaluator.SafeThread2.<>c__DisplayClass9_0.<CreateAction>b__0(Object o)
    at Microsoft.Mashup.Container.EvaluationContainerMain.SafeRun(String[] args)
    at Microsoft.Mashup.Container.EvaluationContainerMain.Main(String[] args)
    --- End of inner exception stack trace ---
    at Microsoft.Mashup.Evaluator.SimpleDocumentEvaluator.<>c__DisplayClass3_0.<BeginGetResult>b__0(EvaluationResult2`1 result)
    --- End of inner exception stack trace ---
    at Microsoft.Mashup.Evaluator.SimpleDocumentEvaluator.<>c__DisplayClass3_0.<BeginGetResult>b__0(EvaluationResult2`1 result)
    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.Interface.IDocumentEvaluatorExtensions.GetResult[T](IDocumentEvaluator`1 evaluator, DocumentEvaluationParameters parameters)
    at Microsoft.Mashup.Evaluator.RemoteDocumentEvaluator.Service.OnBeginGetResult[T](IMessageChannel channel, BeginGetResultMessage message, Action`1 action)
    at Microsoft.Mashup.Evaluator.RemoteDocumentEvaluator.Service.OnBeginGetPreviewValueSource(IMessageChannel channel, BeginGetPreviewValueSourceMessage message)
    at Microsoft.Mashup.Evaluator.MessageHandlers.TryDispatch(IMessageChannel channel, Message message)
    at Microsoft.Mashup.Evaluator.ChannelMessenger.ChannelMessageHandlers.TryDispatch(IMessageChannel channel, Message message)
    at Microsoft.Mashup.Evaluator.MessageHandlers.Dispatch(IMessageChannel channel, Message message)
    at Microsoft.Mashup.Evaluator.ChannelMessenger.OnMessageWithUnknownChannel(IMessageChannel baseChannel, MessageWithUnknownChannel messageWithUnknownChannel)
    at Microsoft.Mashup.Evaluator.MessageHandlers.TryDispatch(IMessageChannel channel, Message message)
    at Microsoft.Mashup.Evaluator.ChannelMessenger.ChannelMessageHandlers.TryDispatch(IMessageChannel channel, Message message)
    at Microsoft.Mashup.Evaluator.MessageHandlers.Dispatch(IMessageChannel channel, Message message)
    at Microsoft.Mashup.Evaluator.EvaluationHost.Run()
    at Microsoft.Mashup.Container.EvaluationContainerMain.Run(Object args)
    at Microsoft.Mashup.Evaluator.SafeThread2.<>c__DisplayClass9_0.<CreateAction>b__0(Object o)
    at Microsoft.Mashup.Container.EvaluationContainerMain.SafeRun(String[] args)
    at Microsoft.Mashup.Container.EvaluationContainerMain.Main(String[] args)
    --- End of inner exception stack trace ---
    at Microsoft.Mashup.Evaluator.RemoteDocumentEvaluator.Service.<>c__DisplayClass9_1.<OnBeginGetPreviewValueSource>b__1()
    at Microsoft.Mashup.Evaluator.RemotePreviewValueSource.<>c__DisplayClass0_0.<RunStub>b__0()
    at Microsoft.Mashup.Evaluator.EvaluationHost.ReportExceptions(String entryName, IEngineHost engineHost, IMessageChannel channel, Action action)
    --- End of inner exception stack trace ---
    at Microsoft.Mashup.Evaluator.EvaluationHost.<>c__DisplayClass17_0.<TryReportException>b__1()
    at Microsoft.Mashup.Common.SafeExceptions.IgnoreSafeExceptions(IEngineHost host, IHostTrace trace, Action action)
    at Microsoft.Mashup.Evaluator.EvaluationHost.TryReportException(IHostTrace trace, IEngineHost engineHost, IMessageChannel channel, Exception exception)
    at Microsoft.Mashup.Evaluator.EvaluationHost.ReportExceptions(String entryName, IEngineHost engineHost, IMessageChannel channel, Action action)
    at Microsoft.Mashup.Evaluator.RemoteDocumentEvaluator.Service.<>c__DisplayClass12_1`1.<OnBeginGetResult>b__0()
    at Microsoft.Mashup.Evaluator.EvaluationHost.ReportExceptions(IHostTrace trace, IEngineHost engineHost, IMessageChannel channel, Action action)
    at Microsoft.Mashup.Evaluator.RemoteDocumentEvaluator.Service.OnBeginGetResult[T](IMessageChannel channel, BeginGetResultMessage message, Action`1 action)
    at Microsoft.Mashup.Evaluator.RemoteDocumentEvaluator.Service.OnBeginGetPreviewValueSource(IMessageChannel channel, BeginGetPreviewValueSourceMessage message)
    at Microsoft.Mashup.Evaluator.MessageHandlers.TryDispatch(IMessageChannel channel, Message message)
    at Microsoft.Mashup.Evaluator.ChannelMessenger.ChannelMessageHandlers.TryDispatch(IMessageChannel channel, Message message)
    at Microsoft.Mashup.Evaluator.MessageHandlers.Dispatch(IMessageChannel channel, Message message)
    at Microsoft.Mashup.Evaluator.ChannelMessenger.OnMessageWithUnknownChannel(IMessageChannel baseChannel, MessageWithUnknownChannel messageWithUnknownChannel)
    at Microsoft.Mashup.Evaluator.MessageHandlers.TryDispatch(IMessageChannel channel, Message message)
    at Microsoft.Mashup.Evaluator.ChannelMessenger.ChannelMessageHandlers.TryDispatch(IMessageChannel channel, Message message)
    at Microsoft.Mashup.Evaluator.MessageHandlers.Dispatch(IMessageChannel channel, Message message)
    at Microsoft.Mashup.Evaluator.EvaluationHost.Run()
    at Microsoft.Mashup.Container.EvaluationContainerMain.Run(Object args)
     Microsoft.Mashup.Host.Document.Analysis.PackageDocumentAnalysisInfo.PackagePartitionAnalysisInfo.SetPreviewValue(EvaluationResult2`1 result, Func`1 getStaleSince, Func`1 getSampled)