New Power BI update lets you add parameters to a URL

by Vlad Turiceanu
Vlad Turiceanu
Vlad Turiceanu
Editor-in-Chief
Passionate about technology, Windows, and everything that has a power button, he spent most of his time developing new skills and learning more about the tech world. Coming... read more
Affiliate Disclosure
Power BI URL parameters for paginated reports

XINSTALL BY CLICKING THE DOWNLOAD FILE
To fix various PC problems, we recommend DriverFix:
This software will keep your drivers up and running, thus keeping you safe from common computer errors and hardware failure. Check all your drivers now in 3 easy steps:

  1. Download DriverFix (verified download file).
  2. Click Start Scan to find all problematic drivers.
  3. Click Update Drivers to get new versions and avoid system malfunctionings.
  • DriverFix has been downloaded by 0 readers this month.

After receiving a new set of capacity settings to give more control to admins, Power BI‘s August update brought new features like grouping and Analytics.

Power BI gets URL parameters for Paginated Reports

Now, Microsoft has released a new update to introduce the support for URL parameters for paginated reports in the Power BI service.

In other words, report authors now have the ability to send commands to paginated reports in Power BI by just adding a parameter to a URL.

When you create a report parameter in Power BI Report Builder, you set a parameter name. If you want to use report parameters, you’ll have to add rp: in front of the parameter name for Power BI to recognize it in the URL.

For example, to set a report parameter in an URL, you’ll have to use rp:parameter=value.

Here’s how Christopher Finlan, Principal Program Manager for Power BI is describing the use of URL parameters:

So if I want to specify a value for the “Salesperson” parameter for my report in an app, I’d use the following URL: https://app.powerbi.com/groups/me/apps/xxxxxxx-c4c4-4217-afd9-3920a0d1e2b0/rdlreports/b1d5e659-639e-41d0-b733-05d2bca9853c?rp:Salesperson=Tiggee

If “Salesperson” was instead a multi-value parameter that accepted multiple values, I can use an & to add an additional parameter value to my URL like so – https://app.powerbi.com/groups/me/rdlreports/xxxxxxx-abc7-40f0-b456-febzf9cdda4d?rp:Salesperson=Tie+Bear&rp:Salesperson=Mickey

The new Generate Link feature easily integrates with URL parameters

Furthermore, Microsoft also announced the introduction of a new feature this week called Generate Link.

This feature aims to help with the discovery of the parameter names by generating a link of the current report with the parameter values appended to the URL.

Also, besides report parameters, you can set the export format of your report in the URL. Using the rdl: prefix will allow you to set the output format in which the report can be downloaded directly into the URL.

Here’s how it should look like if the output format is designated as PDF:

https://app.powerbi.com/groups/me/apps/xxxxxxx-c4c4-4217-afd9-3920a0d1e2b0/rdlreports/b1d5e659-639e-41d0-b733-05d2bca9853c?rp:Salesperson=Tiggee&rdl:format=PDF

If you want to learn more about URL parameters and see more examples, be sure to check Microsoft’s official documentation page.

READ ALSO:

idee restoro Still having issues? Fix them with this tool:
  1. Download this PC Repair Tool rated Great on TrustPilot.com (download starts on this page).
  2. Click Start Scan to find Windows issues that could be causing PC problems.
  3. Click Repair All to fix issues with Patented Technologies (Exclusive Discount for our readers).

Restoro has been downloaded by 0 readers this month.