Create an embedded data source for paginated reports in the Power BI service
APPLIES TO: Power BI Report Builder Power BI Desktop
This article explains how to create and modify an embedded data source for a paginated report in the Power BI service. You define an embedded data source in a single report, and use it only in that report. Paginated reports published to the Power BI service can't use shared datasets and data sources. Here are some of the data sources you can connect to:
- Azure SQL Database and Azure Synapse Analytics through Basic and oAuth
- Azure Analysis Services through SSO
- SQL Server through a gateway
- Power BI datasets
For a complete list, see Supported data sources for Power BI paginated reports.
Paginated reports connect to on-premises data sources by way of a Power BI gateway. You set up the gateway after you publish the report to the Power BI service.
For more information, see Understanding report data in Power BI Report Builder.
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.
Create an embedded data source
Open Power BI Report Builder.
On the toolbar in the Report Data pane, select New > Data Source. The Data Source Properties dialog box opens.
In the Name text box, type a name for the data source or accept the default.
From the Select connection type list, select a data source type.
Specify a connection string by using one of these methods:
Type the connection string directly in the Connection string text box.
Select Build to open the Connection Properties dialog box for the data source you chose in step 2.
Fill in the fields in the Connection Properties dialog box as appropriate for the data source type. Connection properties include the type of data source, the name of the data source, and the credentials to use. After you specify values in this dialog box, select Test Connection to verify that the data source is available and that the credentials you specified are correct.
Specify the credentials to use for this data source. The owner of the data source chooses the type of credentials that are supported. For more information, see Specify credential and connection information for Report Data sources.
The data source appears in the Report Data pane.
Considerations and limitations
Paginated reports that connect to Power BI datasets follow the rules for shared datasets in Power BI with some minor changes. For users to properly view paginated reports that use Power BI datasets, and to ensure row-level security (RLS) is enabled and enforced for your viewers, follow these rules:
|.rdl in same workspace as dataset||Supported|
|Shared .rdl||You need Read permission assigned for each user viewing the report at the dataset level|
|Shared app||You need Read permission assigned for each user viewing the report at the dataset level|
|.rdl in same workspace as dataset (different user)||Supported|
|.rdl in different workspace as dataset (different user)||You need Read permission assigned for each user viewing the report at the dataset level|
|Row-level security||You need Read permission assigned for each user viewing the report at the dataset level to have it enforced|
Submit and view feedback for