Embed Power BI paginated reports
With Power BI embedded analytics you can create Power BI content that displays paginated reports in an application that is fully integrated and interactive. You can embed paginated reports using the solution that best works for you, embed for your customers or embed for your organization.
This article describes how to embed paginated reports using the embedding sample tutorials.
To get started, you're required to have:
Your own Azure Active Directory tenant setup
If you don't have an Azure subscription, create a free account before you begin.
- You must use a service principal. Master user is not supported.
- Premium Per User (PPU) is not supported.
- Datasources that require single sign-on (SSO), are not supported. For a list of supported datasets and their authentication methods, see Supported data sources for Power BI paginated reports.
- Power BI dataset is not supported as a datasource.
To embed a paginated report using the sample app, follow these steps:
Step 1 - Create a workspace
Your service principal must also be an admin or member of the Power BI workspaces.
Step 2 - Create a capacity
Before you import or upload a paginated report to embed, the workspace containing the report must be assigned to a capacity. There are two types of capacity you can choose from:
Power BI Premium - For embedding a paginated report, an EM or P SKU is required. For more information regarding this subscription, see What is Power BI Premium?
Azure Power BI Embedded - You can purchase a capacity from the Microsoft Azure portal. This subscription uses the A SKUs. For details on how to create a Power BI Embedded capacity, see Create Power BI Embedded capacity in the Azure portal.
Power BI Embedded recently released a new version, called Embedded Gen2. Embedded Gen2 simplifies the management of embedded capacities, and improves the Power BI Embedded experience. For more information, see Power BI Embedded Generation 2.
The table below describes the resources and limits of each SKU. To determine which capacity best fits your needs, see the which SKU should I purchase for my scenario table.
|Capacity Nodes||Total v-cores||Backend v-cores||Frontend v-cores||RAM (GB)|
|EM1/A1 with Embedded Gen2||1||0.5||0.5||2.5|
|EM2/A2 with Embedded Gen2||2||1||1||5|
|EM3/A3 with Embedded Gen2||4||2||2||10|
Step 3 - Assign a workspace to a capacity
Once you create a capacity, you can assign your app workspace to that capacity.
You can also import paginated reports into a new workspace using the Power BI REST APIs.
Step 4 - Enable paginated reports workload
After creating a capacity and assigning your workspace to it, you need to enable the paginated report workload on your capacity.
Sign into Power BI > Admin portal > Capacity settings.
Select the capacity that has the workspace you want to add a paginated report to.
Activate the paginated reports workload.
Step 5 - Create and upload your paginated report
The user uploading the paginated report must have a Power BI Pro or Premium Per User (PPU) license to publish to a workspace.
Step 6 - Embed content using the sample application
Follow the instructions in the embed content for your customers tutorial.
Skip Step 4 - Create and publish a Power BI report and use the paginated report you uploaded, instead of the sample report suggested in the tutorial.
powerbi.bootstrap method isn't supported when embedding paginated reports.