cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
SwagatikaBehera
Frequent Visitor

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 5
v-deddai1-msft
Community Support
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

v-deddai1-msft
Community Support
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-b...

 

And use these three parameters when you get data from the api:

 

Capture1.PNGCapture2.PNG

 

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

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
Super User IV
Super User IV

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.

Helpful resources

Announcements
MBAS on Demand

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

July 2021 Update 768x460.png

Check it out!

Click here to read more about the July 2021 Updates

Power Query PA Forum 768x460.png

Check it out!

Did you know that you can visit the Power Query Forum in Power BI and now Power Apps

Top Solution Authors
Top Kudoed Authors