Dogodek
Pridobite potrdilo v storitvi Microsoft Fabric – brezplačno!
19. nov., 23h - 10. dec., 23h
Za omejen čas ekipa Microsoft Fabric Community ponuja brezplačne kupone za izpit DP-600.
Pripravite se zdajTa brskalnik ni več podprt.
Izvedite nadgradnjo na Microsoft Edge, če želite izkoristiti vse prednosti najnovejših funkcij, varnostnih posodobitev in tehnične podpore.
APPLIES TO: Power BI Report Builder Power BI Desktop
You can pass report parameters to a report by including them in a report URL for Paginated Reports. These URL parameters are not prefixed because they are passed directly to the report processing engine.
All query parameters can have corresponding report parameters. You pass a query parameter to a report by passing the corresponding report parameter. For more information, see Build a Query in the Relational Query Designer (Power BI Report Builder).
Report parameters are case-sensitive and utilize the following special characters:
To set a report parameter within a URL, use the following syntax:
rp:parameter=value
For example, to specify two parameters, "Salesperson" and "State", defined in a report in My Workspace, you'd use the following URL:
https://app.powerbi.com/groups/me/rdlreports/xxxxxxx-abc7-40f0-b456-febzf9cdda4d?rp:Salesperson=Tie+Bear&rp:State=Utah
To specify the same two parameters defined in a report in an app, you'd use the following URL:
https://app.powerbi.com/groups/me/apps/xxxxxxx-c4c4-4217-afd9-3920a0d1e2b0/rdlreports/xxxxxxx-639e-41d0-b733-05d2bca9853c?rp:Salesperson=Tiggee&rp:State=Utah
To pass a null value for a parameter, use the following syntax:
parameter:isnull=true
For example,
rp:SalesOrderNumber:isnull=true
To pass a Boolean value, use 0 for false and 1 for true. To pass a Float value, include the decimal separator of the server locale.
Opomba
If your report contains a report parameter that has a default value and the value of the Prompt property is false (that is, the Prompt User property is not selected in Report Manager), then you cannot pass a value for that report parameter within a URL. This provides administrators an option for preventing end users from adding or modifying the values of certain report parameters.
The following URL example includes a multi-value parameter "Salesperson”. The format for a multi-value parameter is to repeat the parameter name for each value.
https://app.powerbi.com/groups/me/rdlreports/xxxxxxx-abc7-40f0-b456-febzf9cdda4d?rp:Salesperson=Tie+Bear&rp:Salesperson=Mickey
The following URL example passes a single parameter of SellStartDate with a value of "7/1/2005".
https://app.powerbi.com/groups/me/rdlreports/xxxxxxx-abc7-40f0-b456-febzf9cdda4d?rp:SellStartDate=7/1/2005
Dogodek
Pridobite potrdilo v storitvi Microsoft Fabric – brezplačno!
19. nov., 23h - 10. dec., 23h
Za omejen čas ekipa Microsoft Fabric Community ponuja brezplačne kupone za izpit DP-600.
Pripravite se zdajUsposabljanje
Modul
Create paginated reports - Training
Paginated reports allow report developers to create Power BI artifacts that have tightly controlled rendering requirements. Paginated reports are ideal for creating sales invoices, receipts, purchase orders, and tabular data. This module will teach you how to create reports, add parameters, and work with tables and charts in paginated reports.
Potrdilo
Microsoft Certified: Power BI Data Analyst Associate - Certifications
Demonstrate methods and best practices that align with business and technical requirements for modeling, visualizing, and analyzing data with Microsoft Power BI.