Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
APPLIES TO:
Power BI service
Power BI Report Builder
Power BI Desktop
This article describes how to start creating a paginated report in the Power BI service. Use this feature to create paginated reports in any workspace in the Power BI service, including workspaces that aren't in a Power BI Premium capacity.
Important
The methods in this article create new, standalone paginated reports. You can't add paginated report pages to an existing Power BI report (.pbix file) or convert a Power BI report into a paginated report. Paginated reports and Power BI reports are separate report types with different file formats and capabilities. For ways to use both report types together, see Use paginated reports with Power BI reports.
To create a paginated report from the Power BI service, you can start in a number of places:
- List view in the Power BI service
- Data hub view in the Power BI service
- The Dataset details page in the Power BI service
- Power BI Desktop
Prerequisites
License requirements for Power BI paginated reports (.rdl files) are the same as for Power BI reports (.pbix files).
- You don't need a license to download Power BI Report Builder from the Microsoft Download Center for free.
- With a free license, you can publish paginated reports to My Workspace in the Power BI service. For more information, see Feature availability for users with free licenses in the Power BI service.
- With a Power BI Pro license or a PPU license, you can publish paginated reports to other workspaces. You also need at least a contributor role in the workspace.
- You need Build permission for the dataset.
List view in the Power BI service
Go to list view for any workspace, including My Workspace.
Select More options (...) for a Power BI semantic model, and then select Create formatted table.
Data hub view in the Power BI service
Go to Data hub view in the Power BI service.
Select More options (...) next to a dataset > Create paginated report.
The Dataset details page in the Power BI service
Select a dataset in the Data hub view of the Power BI service.
Under Visualize this data, select Create a report > Paginated report.
Power BI Desktop
Open Power BI Desktop, and on the Insert tab, select Visual gallery. Scroll down to the Other section and select Paginated report.
In the visual, select Create paginated report.
The Power BI service opens.
In the Choose the data you want to connect window, filter or browse to the dataset you want, and select Connect.
Use paginated reports with Power BI reports
Although paginated reports and Power BI reports are separate report types that can't be combined into a single file, you can integrate them in your workspace:
- Publish both reports to the same workspace in the Power BI service.
- Link between reports: Add buttons or links in your Power BI report that open the paginated report, or vice versa. For more information, see Add a link to a URL in a report.
- Include in an app: When you publish a workspace as an app, you can include both Power BI reports and paginated reports in the same app for unified distribution.
- Pin to dashboards: You can pin visuals from both report types to the same dashboard for a unified view.
By using this approach, you can leverage the strengths of both report types: interactive analysis with Power BI reports and pixel-perfect, printable layouts with paginated reports.
Considerations and limitations
- You can create a paginated report in any workspace.
- You can't create a paginated report from Power BI semantic models based on a live connection to SQL Server Analysis Service (SSAS) or Azure Analysis Service (AAS). In this case, you should connect your paginated report directly to the underlying SSAS/AS database.
- The online editor doesn't replicate all existing Power BI Report Builder functionality.