Skip to main content

Paginated Report November 2020 Feature Summary

We have several updates rolling out this month for paginated reports as we get ready for the launch of the Premium per user public preview.  These updates include new paginated reports samples, in-product parameter updates and more. Check out the full blog to learn more about all the updates and enhancements.

Paginated Report Sample Reports

We are excited to introduce new official paginated report samples for you to download and use in the Power BI service.

Download Paginated Report sample reports

They reflect several typical scenarios you might use paginated reports in, including –

  • An operational report around sales performance
  • An invoice generated for a customer
  • A course transcript
  • Mailing labels
  • A formal receipt mailed to a customer

These reports use common authoring features and techniques folks can look at as they author paginated reports for the first time such as:

  • Report parameters that allow you to select the dynamic content and theme.
  • Data regions such as a Tablix to display user specific content
  • Report items such as text boxes and lines
  • Rectangular data region to create a well formatted layout
  • Images to personalize content.
  • All visuals follow WCAG 2.1 compliance guidelines e.g. color contrast between font and background are at least 4.5:1, color contrast between non-decorative non-text elements and their background is at least 3:1

We want to extend a huge thank you to Meagan Longoria, Microsoft Data Platform MVP and community accessibility advocate for her contributions in helping make these samples accessible. If you want to follow some of Meagan’s accessibility checklist, you can check out this article from her blog.  To learn more, check out the paginated reports samples documentation.

Download a connected paginated report from a Power BI dataset

To help get started building a paginated report against a Power BI dataset, we’ve added the ability to download the rdl file from the Power BI service with the connection information already defined for the selected Power BI dataset.  Simply choose any Power BI dataset in the service you have access to and right-click on the dataset.  You’ll see the option to “Download the .rdl”.  To learn more, click on Download the .rdl for a Power BI paginated report from a dataset

Note: It is strongly recommended you download the latest version of  Power BI Report Builder to open the RDL file as the new connection string format is only compatible in the latest version of PBIRB.

Download Power BI Report Builder

Search in parameter dropdowns in Power BI

We have addressed  one of the top usability issues related to parameter dropdowns in the Power BI service. You can now use a fuzzy text search to better filter the value you’re looking for so you don’t have to scroll through a long list to get the selected item.  To learn more, check out the documentation around Parameters for paginated reports in the Power BI service

Page view mode URL parameter

You can pass “rdl:reportView=pageView” as part of a URL to configure the look and feel of your paginated reports in Power BI and render the report in page view mode instead of interactive. To learn more, click on the documentation for URL access parameter references

Also, if you haven’t already registered your tenant to get priority access to the upcoming public preview of Power BI Premium per user, make sure you check out the blogpost and get registered so you can use all the premium capabilities, including paginated reports, for free during the public preview.

We hope you’re as excited about these changes as we are.  Be  sure to leave your feedback in the comments below, and feel free to submit your  feature  in the Power BI ideas forum.