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,

What is the result when you add the following code to Advanced Editor of a blank query ?

let
    Origen = executeQuery3([entity="product", xpaths="name"]),
    Source =Json.Document(Origen)
in
    Source



Regards,
Lydia

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Hi, I got the same error mentioned above.

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Anonymous,

      How do you create the following function? Based on the above error message, the issue is releated to the Origen method.

      let
    Origen = OData.Feed("MY-ODATA-URL", null, [Implementation="2.0"]),
    #"executeQuery3_function (parameters as record) as table" = Origen{[Name="executeQuery3",Signature="function (parameters as record) as table"]}[Data]
in
    #"executeQuery3_function (parameters as record) as table"



      Regards,
      Lydia

      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago

        When I press "Get Data", I select OData feed then, I fill up the URL and authentication fields and I choose the function that I want to call. See the below image

         

         

         

        In that way I create the executeQuery3 function. That function comes from my OData implementation, it expects 1 argument with the next format:

        {
    "parameters": {
        "entity": "product",
        "xpaths": "name,SKU"
    }
}

         

        I think I am not doing something wrong.

         

        Thanks for your help.