Forum Discussion

jecrygier's avatar
jecrygier
Regular Visitor
5 years ago

PBIRS REST API - Get Parameters With Value

Hello -   I'm currently doing a PoC with PBIRS, where I need to pre-select Report Parameters.  I've found the REST API /Reports({Id})/ParameterDefinitions, and this gets me a given Report's Paramet...
parameters
REST API
jecrygier's avatar
jecrygier
Regular Visitor
5 years ago

Hi v-janeyg-msft -

 

Thanks for the reply.  We have a requirement where we need to be able to create "Saved Filters", which will be a screen before we render the actual report.  Due to this, when I did a PoC in SSRS, I was using the GetItemParameters via SOAP to get the Parameters for a report.  I have found the ParameterDefinitions REST API that is nearly equivalent...but doesn't seem to let me handle situations like cascading dropdowns.

 

So, our plan is to somehow get the parameters for the reports, while allowing for things like cascading dropdowns interactively, before rendering the report.  Then, forward to the report server while passing in the selected filters as you describe above.

 

I just can't seem to figure out how to do the cascading dropdown part in REST (as we prefer it over SOAP).

 

Thanks again!

v-janeyg-msft's avatar
v-janeyg-msft
Community Support
5 years ago

Hi, jecrygier 

 

'So, our plan is to somehow get the parameters for the reports, while allowing for things like cascading dropdowns interactively, before rendering the report.  Then, forward to the report server while passing in the selected filters as you describe above.'

 

I tried to understand you, but failed. It's hard for me to find information related to what you are talking about in powerbi. Do you want to open the report on PBI report server? When the report is made, you can control how it displays when it is opened. Why make simple things complicated?

Calling SOAP API in Power BI (Read XML Web Service data) | ZappySys Blog

 

Best Regards

Janey Guo

  • jecrygier's avatar
    jecrygier
    Regular Visitor
    5 years ago

    Hi v-janeyg-msft -

     

    Unfortunately, our business requirements are forcing us to be a bit more complicated than we want.  We have a requirement to save a set of filters that an individual user will commonly use.  For example, if we have a report that has Country as a parameter, and Region as a parameter, one individual will commonly view the report for "USA" / "Midwest" and another might commonly view the report for "USA" / "South".  They don't want to have to pick these filters from a dropdown every time the go into the system.

     

    These parameter selections also happen to be configured in the RDL, and in the example above, "Region" would be dependent on "Country".  So, when I pick "USA", the Region dropdown only shows USA regions, and not Australia regions.  This functionality is built into PBIRS when I render a report.  I just need it outside of rendering, so I can handle the 'saving' part.

     

    Again, I have found this to be possible over SOAP (ReportingService2010.GetItemParameters(String, String, Boolean, ParameterValue[], DataSourceCredentials[]) Method (ReportService2010) | Microsoft Docs)...but greatly prefer to do it via the REST interface, as it seems more flexible, and has more information.

     

    Thanks again

    --John