How to extract SSRS Reports RDL using Web Service from PowerBI.com

[kaushikmakadia]

Hi there,

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

[v-henryk-mstf]

Hi @kaushikmakadia ,

Whether the advice given by @d_gosbell  has solved your confusion, if the problem has been solved you can mark the reply for the standard answer to help the other members find it more quickly. If not, please point it out.

Looking forward to your feedback.

Best Regards,
Henry

[d_gosbell · Accepted solution]

For option 1 I think you can use this API

Reports - Export To File In Group - REST API (Power BI Power BI REST APIs) | Microsoft Docs

For option 2 - Power BI Report Server is built on the same base as SSRS so all the same web service calls work.