Power BI Rest API - Retrieve Paginated Reports Parameters

[GrantTrevor]

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?

[Hanuma_AB]

Hi @GrantTrevor 

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

Thanks

Hanuma

[GrantTrevor]

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.

[millwardt]

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

[v-lionel-msft · Accepted solution]

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.