Currently, we have a on-premises SSRS 2016 (SQL Server Reporting Service in standalone mode) server and it has many paginated reports (RDL files) with pre-formatted business requirement. One of our company's application uses the Report Server Web Service Endpoints functionality (i.e. http://mySSRSsrv/ReportServer/ReportService2010.asmx ) to extract many reports automatically into various format such as Excel, CSV and PDF per needs. See this for more: Report Server Web Service Endpoints - SQL Server Reporting Services (SSRS) | Microsoft Docs
We intend to migrate all of the RDL’s SSRS files with 2 x design alternatives-
(Prefer Option 1) Deploy all paginated reports RDL's into the Power BI Service workspace in the cloud (knows as www.powerbi.com) . However, how can above application extract the RDL’s report output into Excel, CSV and PDF as to our knowledge PowrBI.com service does not provide or expose any web-service or alternative to achieve that? Any help please.
Note we have PBI Premium capacity.
(Option 2) Deploy all paginated reports RDL's into an On-premises Power BI Report Server. But once again, how can above application extract the RDL's report output into Excel, CSV and PDF as to our knowledge PowerBI Report Server does not offer or expose any web-service to acheive that? Any help please