Using of URL parameters in reports after moving from ssrs to powerbi

[m_andel]

I have plenty of SSRS reports. The parameters in these reports can be set via URL Parameters. 

We have moved these reports to powerbi. It seems that it is not possible to control the parameters via URL parameters on powerbi. Is this correct? Is there a workaround? The filter parameter doesn't seem to work either.

[rajendraongole1 · Accepted solution]

Hi @m_andel  - Power BI does not natively support URL parameters to control filter values in the same way as SSRS does.

Power BI allows the use of query string parameters to apply filters to reports. You can append a filter to the report URL using the following syntax:

SQL script eg: 

https://app.powerbi.com/groups/<workspace_id>/reports/<report_id>?filter=Year/Year eq 2023

If you still need to emulate SSRS-like functionality for parameterized reports, you can use Power BI Report Builder to create paginated reports. These reports support parameters and can be controlled via URL parameters in a manner similar to SSRS.

If strict URL parameter functionality is required, you may need to use Power BI Report Builder for paginated reports.Implement embedding with the Power BI API for more dynamic solutions.

[m_andel]

Our migrated reports ARE actually paginated reports. But URL parameters are not automatically recognized as report parameters. The internal name of the parameter in my example is "Jahr", so it should work with the url parameter "Jahr", right?
Or do i have to set any settings in the report builder? I could not find any settings for this.

[m_andel]

@rajendraongole1 i just figured out, that you have to address the parameter names with 'rp:'