Forum Discussion

SwagatikaBehera's avatar
SwagatikaBehera
Frequent Visitor
5 years ago

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