Paginated report - using SOAP to get data

[Markzolotoy]

There is a report that pulls data from on-prem SQL server. Now it's moving to Azure. The provider is giving a SOAP envelope to access data. How that can be used in a paginated report? No Powerbi datasets solution is available at this time.

Thanks

[v-kkf-msft]

Hi @Markzolotoy ,

In Reporting Services, there is a XML data source type which can connect to and retrieve data from XML documents, Web services, or XML that is embedded in the query. Please try to open a connection use XML data source type to retrieve data. For more information, please refer to links below: 

Consuming a WCF Service from an SSRS (RDL) Server Report 

Using WCF endpoints with SQL Reporting Services 

How to get data from a SOAP WS with Power BI 

Best Regards,
Winniz

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.