User Profile
jecrygier
Regular Visitor
Joined 5 years ago
User Widgets
Contributions
Re: PBIRS REST API - Get Parameters With Value
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 --John2.6KViews0likes1CommentRe: PBIRS REST API - Get Parameters With Value
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!2.6KViews0likes3CommentsPBIRS 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 Parameters. However, I cannot find a way to make this call while posting the current set of parameter values. For example, I have a report that takes in a Year and Month. The month is a relative number to today. So, if I'm rendering the report for March-2021, it will be Year=2021, Month=0. If I switch the year to 2022, I need to re-fetch the parameters, as March-2022 would be Year=2022, Month=12, which don't come back in the first call to ParameterDefinitions. This was possible with the SOAP API for SSRS, via GetItemParameters, and including something like: <Values> <ParameterValue> <Name>Year</Name> <Value>2022</Value> </ParameterValue> </Values> In the request. However, I'm having troubles finding an equivilent in the REST API. Thanks in advance!2.8KViews0likes5Comments
Data Privacy
Microsoft Fabric Community and Privacy
To learn more about how we manage your data, please review the Microsoft Fabric Community Data Privacy guide.