URL parameters in paginated reports in Power BI

You can send commands to paginated reports in Power BI by adding a parameter to a URL. For example, you may have viewed the report using a specific set of report parameter values. You encapsulate this information in the URL by using predefined URL access parameters. You further customize how Power BI processes the report by embedding parameters for rendering formats, or for the look and feel of the report toolbar. You then paste this URL directly into an email or Web page so others experience your report in the same manner in the browser.

Here are actions you can perform through URL access parameters:

  • Send report parameters to a report.
  • Initiate the export of the report content in a supported file format.
  • Hide or view the parameters pane.
  • Specify DeviceInfo setting.

For the complete list of commands and settings available through URL access, see URL access parameter reference later in this article.

URL access concepts

URL requests to Power BI contain parameters that are processed by the service. The way in which the service handles URL requests depends on the parameters, parameter prefixes, and types of items that are included in the URL. Paginated report URL functionality is compatible with most browsers and applications that support standard URL addressing.

URL access syntax

URL requests can contain multiple parameters, listed in any order. Parameters are separated by an ampersand (&). Name and value pairs are separated by an equal sign (=). For example:

powerbiserviceurl?rp:parametervalueh&rdl:parameter=value  

Syntax description

powerbiserviceurl

The Web service URL of your Power BI tenant. For example:

& Used to separate name and value pairs of URL access parameters.

prefix A prefix for the URL parameter (for example, rp: or rdl:) that specifies an action in the Power BI service.

Note

Report parameters require a parameter prefix and are case-sensitive.

parameter The parameter name.

value

URL text corresponding to the value of the parameter being used.

For examples of passing report parameters on the URL, see Pass a report parameter in a URL.

URL access parameter reference

You can use the following parameters as part of a URL to configure the look and feel of your paginated reports in Power BI. The most common parameters are listed in this section. Parameters are case-insensitive and begin with the parameter prefix rdl: if related to the output format.

Report commands (rdl:)

Export format Specifies the format in which to render and export a report. Available values are:

  • PPTX (PowerPoint)
  • MHTML
  • IMAGE
  • EXCELOPENXML (EXCEL)
  • WORDOPENXML (WORD)
  • CSV
  • PDF
  • XML

Device Info You may specify additional output parameters for the following export formats.

PDF:

  • rdl:AccessiblePDF=true/false
  • rdl:Columns=integer
  • rdl:ColumnSpacing=decimal(in)
  • rdl:DpiX=integer
  • rdl:DpiY=integer
  • rdl:EndPage=integer
  • rdl:HumanReadablePDF=true/false
  • rdl:MarginBottom=decimal(in)
  • rdl:MarginLeft=decimal(in)
  • rdl:MarginRight=decimal(in)
  • rdl:MarginTop=decimal(in)
  • rdl:PageHeight=decimal(in)
  • rdl:PageWidth=decimal(in)
    • rdl:StartPage=integer

CSV:

  • rdl:Encoding=string
  • rdl:ExcelMode=true/false
  • rdl:FieldDelimiter=string
  • rdl:FileExtension=string
  • rdl:NoHeader=true/false
  • rdl:Qualifier=string
  • rdl:RecordDelimiter=string
  • rdl:SuppressLineBreaks=true/false
    • rdl:UseFormattedValues=true/false

WORDOPENXML (WORD):

  • rdl:AutoFit=string -> True/False/Never/Default
  • rdl:ExpandToggles=true/false
  • rdl:FixedPageWidth=true/false
  • rdl:OmitHyperlinks=true/false
  • rdl:OmitDrillthroughs=true/false

EXCELOPENXML (EXCEL):

  • rdl:OmitDocumentMap=true/false
  • rdl:OmitFormulas=true/false
    • rdl:SimplePageHeaders=true/false

PPTX (PowerPoint):

  • rdl:Columns=integer
  • rdl:ColumnSpacing=decimal(in)
  • rdl:DpiX=integer
  • rdl:DpiY=integer
  • rdl:EndPage=integer
  • rdl:MarginBottom=decimal(in)
  • rdl:MarginLeft=decimal(in)
  • rdl:MarginRight=decimal(in)
  • rdl:MarginTop=decimal(in)
  • rdl:PageHeight=decimal(in)
  • rdl:PageWidth=decimal(in)
  • rdl:StartPage=integer
    • rdl:UseReportPageSize=true/false

XML:

  • rdl:XSLT=string
  • rdl:MIMEType=string
  • rdl:UseFormattedValues=true/false
  • rdl:Indented=true/false
  • rdl:OmitNamespace=true/false
  • rdl:OmitSchema=true/false
  • rdl:Encoding=string
  • rdl:FileExtension=string
  • rdl:Schema=true/false

Next steps