cancel
Showing results for 
Search instead for 
Did you mean: 
Reply

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

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

 

1 ACCEPTED SOLUTION
d_gosbell
Super User
Super User

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.

View solution in original post

2 REPLIES 2
v-henryk-mstf
Community Support
Community Support

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

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.

Helpful resources

Announcements
November 2022 Update

Check it Out!

Click here to read more about the November 2022 updates!

Difinity Conference

Difinity Conference 2022

Difinity is the largest Microsoft Data, AI, Power BI, Power Platform and Business Applications Conference in New Zealand.

European Share Point Conference

European Share Point Conference

This conference returns live and in-person in Copenhagen this 28 November-01 December with 4 Microsoft Keynotes, 9 Tutorials, and 120 Sessions.

Microsoft 365 Conference â__ December 6-8, 2022

Microsoft 365 Conference - 06-08 December

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.