Paginated Reports & Parameterized URLs

[Anonymous]

Is the term "paginated report" just another term for RDL/SSRS?  I have the following requirements and just need to know the best method for implementation.

1.  Create a filtered report, which filters results for a specific location ID.  E.g., total sales by store location.

2.  Use a static URL to pass location ID as a parameter for each location.  The URL has to be static due to the software used to display results on a common screen.  Each location has it's own device to call the static URL and would be stored locally.

Thanks for any assistance you can provide.

[v-yiruan-msft · Accepted solution]

Hi @Anonymous ，

Paginated reports are based on the RDL report technology in SQL Server Reporting Services. You can read the following documentation for the introduction  and some FAQ of paginated reports.

What are paginated reports in Power BI Premium?

Paginated reports in Power BI: FAQ

As for how to pass a report parameter in a URL for a paginated report, you can refer to the official documentations below.

URL parameters in paginated reports in Power BI

Pass a report parameter in a URL for a paginated report in Power BI

https://app.powerbi.com/groups/me/rdlreports/xxxxxxx-abc7-40f0-b456-febzf9cdda4d?rp:Salesperson=Tie+Bear&rp:State=Utah

Paginated Report - Using URL Parameters and Select ALL

Also, there are good video tutorials on paginated reports here, you can watch them to learn more about paginated reports.

Power BI Paginated Reports in a Day course

12 Days of Paginated Reports

Best Regards