Forum Discussion
OData error calling function
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,
LydiaYes, the result is as expected. So, I will use my own function. Thanks for your help.
Hi, I got the same error mentioned above.
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
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.
Anonymous,
The above error message mentions that you should enter a Record value as below.
[entity= "product", xpath= "name,SKU"]
Regards,
LydiaYes, I tried that before but not works, after sending that parameter I got the above exception. I'm stuck there.