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
Carousel_PBI_Wave1

2023 Release Wave 1 Plans

Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.

Power BI Summit Carousel 2

Global Power BI Training

Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!

BizApps LATAM 2023

Business Application LATAM Summit 2023

Join the biggest FREE Business Applications Event in LATAM this February.

Power Platform Bootcamp

Global Power Platform Bootcamp

In this bootcamp we will deep-dive into Microsoft’s Power Platform stack with hands-on sessions and labs, delivered to you by experts and community leaders.