Forum Discussion
How can I read data from a parametrized function of a web service in PowerBI?
There is a function called GetDataRequest() which has 3 parameters and the response function name is GetDataResponse() which returns the resultset in a webservice(https URL). So, I need to call the function GetDataRequest() from PowerBI and provide those 3 parameters , and use GetDataResponse() for resultset in POWERBI. I have tried multiple ways but failed. Is there any way that we can do or its not possible?
In SSRS , I use xml tags to call like below:
<Query>
<Method Name="GetDataRequest" Namespace="http://tempuri.org/">
<Parameters>
<Parameter Name="Id"><DefaultValue>1</DefaultValue></Parameter>
</Parameters>
</Method>
<SoapAction>http://tempuri.org/IWebService/GetDataRequest</SoapAction>
<ElementPath IgnoreNamespaces="true">GetDataRequestResponse{}/GetDataRequestResult{
ID,
Content,
ContentChange,
ContentHint
}
</ElementPath>
</Query>I tried the same way, still its not working. Can somebody please help?
5 Replies
- SwagatikaBeheraFrequent Visitor
This example explains when sql server is a datasource. But I am struggling with calling a webservice with parameterized request function and returns the data from another response function.
- v-deddai1-msft
Community Support
Hi SwagatikaBehera ,
You can create these three parameters in power bi by following steps in https://www.red-gate.com/simple-talk/sql/bi/power-bi-introduction-working-with-parameters-in-power-bi-desktop-part-4/
And use these three parameters when you get data from the api:
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Best Regards,
Dedmon Dai
- SwagatikaBeheraFrequent Visitor
Hi,
Thanks for your reply. Can you please show me a screenshot where to put the function name? Should be the name as a part of URL?
- v-deddai1-msft
Community Support
Hi SwagatikaBehera ,
You can follow the detailed steps in https://www.kizan.com/blog/consuming-xml-web-service-data-in-power-bi
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Best Regards,
Dedmon Dai