Load/Render Paginated report on Power BI report server on-premises

[cynthiarego]

We have a couple of paginated reports in SSRS which we have been loading and rendering in a .net application using the SSRS Report WebService methods via SOAP. (https://learn.microsoft.com/en-us/sql/reporting-services/report-server-web-service/methods/report-se...)

We are looking to migrate these paginated reports to a Power BI Report Server on premises (not Azure). Are there any REST endpoints/webservice end points on the Power BI Report Server that can be used in c# to load and render these reports in csv/pdf format (just like SSRS had)  ?

[cynthiarego]

Hi,

Dont think this endpoint has the Load and Render methods on there. this is just for CRUD on Catalog items, reports etc.

[v-jianpeng-msft]

Hi, @cynthiarego 

Thank you very much for your reply. Your point is great, have you checked the following API for Power BI Report server, which covers all the API interfaces currently published by Power BI Report server:

Power BI Report Server REST API documentation - power-bi-report | Microsoft Learn

Best Regards

Jianpeng Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[cynthiarego · Accepted solution]

• The  ReportExecution2005 endpoint allows developers to programmatically process and render reports in a Report Server. The WSDL for this endpoint is accessed through ReportExecution2005.asmx?wsdl.

This endpoint seemed to work for the Power BI Report Server on prem.

[v-jianpeng-msft]

Hi, @cynthiarego 

You can directly use the SOAP you previously used on the Power BI Report Server. Taking the first SOAP API from the document you provided as an example, simply replace your Report Server with the Power BI Report Server, and you will be able to access the SOAP API just like in SSRS.

How to Get Your Question Answered Quickly

If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

Best Regards

Jianpeng Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.