topic Re: Power BI Rest API - Retrieve Paginated Reports Parameters in Developer

Power BI Rest API - Retrieve Paginated Reports Parameters

GrantTrevor — Fri, 29 Jan 2021 00:54:11 GMT

We're currently exploring the pathway to migrating from SSRS to Power BI. We have 400+ SSRS Reports which we are hoping to convert to run out of Power BI as paginated reports.

Currently when running the reports from SSRS, our web application first asks the SSRS API for the available parameters on a report, and we then show these parameters via our own UI (not the SSRS UI).

Looking through the current Power BI API Documentation I can not find an example of how to retrieve these parameters for a Report, options exist for Datasets, but not on the Report itself.

Does such a capability exist?

Re: Power BI Rest API - Retrieve Paginated Reports Parameters

v-lionel-msft — Mon, 01 Feb 2021 08:18:35 GMT

Hi @GrantTrevor ,

Currently there is no such Rest API.

Best regards,
Lionel Chen

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

Re: Power BI Rest API - Retrieve Paginated Reports Parameters

millwardt — Mon, 24 May 2021 21:03:35 GMT

I also have the same requirement - is this something that may become available in a future release?

Re: Power BI Rest API - Retrieve Paginated Reports Parameters

Hanuma_AB — Wed, 01 Sep 2021 13:34:29 GMT

Hi @GrantTrevor

Did you find any solution to Retrieve Paginated Reports Parameters using REST API or by any method ?

Thanks

Hanuma

Re: Power BI Rest API - Retrieve Paginated Reports Parameters

GrantTrevor — Wed, 01 Sep 2021 22:42:47 GMT

Nothing that is supported in the power bi service/api - currently we're looking looking at parsing the rdl to extract the parameters from it before deployment to the power bi service. We'll store the required parameters for each report in a table and when our users run the reports we'll present the parameters via our own UI prior to the executing the report.