How can I read data from a parametrized function of a web service in PowerBI?

[SwagatikaBehera]

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?

[v-deddai1-msft]

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

[v-deddai1-msft]

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-b...

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

[SwagatikaBehera]

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?

[amitchandak]

@SwagatikaBehera , refer if these can help

https://www.thebiccountant.com/2017/03/22/use-slicers-for-query-parameters-in-powerbi/

https://blog.crossjoin.co.uk/2016/08/16/using-the-relativepath-and-query-options-with-web-contents-i...

[SwagatikaBehera]

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.