topic Re: Load/Render Paginated report on Power BI report server on-premises in Report Server

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

cynthiarego — Wed, 30 Oct 2024 09:39:15 GMT

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-server-web-service-endpoints?view=sql-server-ver16)

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) ?

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

Anonymous — Thu, 31 Oct 2024 02:04:23 GMT

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.

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

cynthiarego — Thu, 31 Oct 2024 09:02:18 GMT

Hi,

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

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

Anonymous — Thu, 31 Oct 2024 09:25:13 GMT

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.

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

cynthiarego — Thu, 31 Oct 2024 11:23:48 GMT

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.