Publish a paginated report to the Power BI service
APPLIES TO: Power BI Report Builder Power BI Desktop
This article explains how to publish a paginated report to the Power BI service by uploading it from your local computer.
Requirements
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.
- If your report data source is on premises, you need to install a gateway. Read more about on-premises gateways. After you upload the report, you connect to the on-premises data source by using the gateway.
From Report Builder, publish to the Power BI service
In Report Builder, create a new paginated report or open an existing paginated report from the Power BI service. If you open an existing paginated report from the service, the Save option is disabled because you're updating a report that's live in the Power BI service.
On the Report Builder File menu, select Publish.
If you aren't signed in to Power BI yet, you need to sign in or create an account now. In the upper-right corner of Report Builder, select Sign in and complete the steps.
In the list of workspaces on the left, select a workspace. Type a File name in the box > Save.
Open the Power BI service in a browser and find the workspace where you published the paginated report.
Select the paginated report to open it in the Power BI service. If it has parameters, you need to select them before you can view the report.
If your report data source is on premises, read about how to connect to a gateway in this article to access the data source.
From the Power BI service, upload a paginated report
You can also start from the Power BI service and upload a paginated report.
Note
Currently, you can't import a paginated report from OneDrive or SharePoint.
Create your paginated report in Report Builder and save it to your local computer.
Open the Power BI service in a browser and find the workspace where you want to publish the report.
Select Upload, then choose Browse to find the paginated report.
To edit your credentials, select the ellipses next to the report name, then choose Manage.
Select Continue > Edit credentials.
Configure your credentials > Sign in.
Select the report to open it in the Power BI service. If it has parameters, you need to select them before you can view the report.
If your report data source is on premises, read about how to connect to a gateway in the following section to access the data source.
Connect to a gateway
As with any other Power BI report, if the paginated report data source is on premises, then you need to create or connect to a gateway to access the data.
Select the settings icon at the top right, then choose Manage connections and gateways.
For more details, see the Power BI service article What is an on-premises data gateway.
Considerations and limitations
- Maximum file size of a paginated report file with extension .rdl is 12 MB. If your RDL file is larger, it is typically due to using large embedded images in which case consider using external images or reducing size of the embedded images.