Forum Discussion
Paginated report - using SOAP to get data
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 data...
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.