Embedding Power BI Content
Add Power BI reports and dashboards to your tenant
You can embed any Power BI reports and dashboards within your Reporting Hub tenant, provided you've granted the Reporting Hub access to your workspace within Power BI (to learn more, see Configure Power BI Workspaces).
Good to Know: Tenant admins can also embed content, depending on their permission level. Permission can be assigned when creating a tenant (see Tenant Admin), or from the Manage Groups settings (see Managing Groups>Setting Admin Permissions).
Add Power BI Report to Main Menu
If you want to house your content within an existing Category, see below. To embed Power BI content within your tenant's menu:
Select your profile picture to access the Admin Settings menu.
Select Manage Content.
Select Manage Content from the Admin Settings menu Select Add New.
Select Create Content Page from the menu that appears. Content pages include Power BI Reports, Dashboards or Paginated Reports.
Create Content Page Select Refresh Workspaces. This ensures the Reporting Hub has up-to-date information from your Power BI Workspaces.
Refresh Workspaces Fill out the following fields:
Name:
Your content name will appear on your Navigation Pane.
Your content name will also show as the title for your content page, if this feature has been enabled on your content page settings (learn more about Content Panes).
Icon (optional):
The icon you select will appear on your Navigation Pane, to the left of your content name.
Description (optional):
Your description will show up beneath the title on your content page, if this feature has been enabled (learn more about Content Panes).
Enable Dynamic Binding toggle: If the report uses dynamic binding, enable this option and fill out the following fields:
Select Power BI Workspace: The workspace where the report is located.
Power BI Content: The report, dashboard or paginated report.
Select Dataset Workspace: This is the workspace where the dataset is located.
Select Dataset: Select the dataset.
Dynamic Binding Example Select your Workspace…:
From the drop-down, select the Workspace that houses the report you wish to embed.
Workspaces will only appear if they have been assigned an Embedded capacity (see Configure Power BI Workspaces).
Power BI Content:
From the drop-down, select the Power BI content you wish to embed. This could be a Power BI report, dashboard or paginated report.
Select Report Page
From the drop-down, select 'All Pages' to include all pages in the report, or select the specific pages you wish to embed. If you select individual pages, they will be displayed in the order they are selected.
Select from the following options:
Filter and Content Pane:
Toggle on or off the features you wish to enable. See Filter and Content Pane Options.
Report Sharing:
Toggle on or off the features you wish to enable. See Report Sharing Options.
Assign Permissions: (Users/Groups):
Select the group(s) that will have access to your report by typing in the first few characters of the group name and selecting the appropriate group from the dropdown.
You may also add individual email accounts. If the user has not been added to a report before, you have to enter their full email address and select the checkmark beside their name on the left side.
Assigning individual users by email address Choose to grant "Editing Permissions" for security groups or users if desired.
If Row Level Security has been enabled for your content, select a Role next to the group or user's name. For more information, see Row Level Security.
Select a role for a RLS-enabled report/dashboard. Enter a Sort Order. This is the position of your report on the Navigation Pane.
Select Save.
For Enterprise and Commercial subscribers, you can also choose to set your report as the landing page for your Reporting Hub by expanding the dropdown menu in the Save icon and selecting Set as "Home Page".
Embedding Content Within Categories
If you don't want your content to be accessed directly via the navigation pane, you can house it within a Category. (See Adding A Category.) To do so:
From your Navigation Settings, find the Parent Category that you want to house your content within. Hover over the category and select the plus icon that appears.
Hover over a category to view the Add Content (+) icon Select Add Content Page, then follow steps 4-9 from the tutorial above.
Add Content Page to a Category
Embedding Content Within Subcategories
Content can also be housed within subcategories. (See Adding a Subcategory.)
To expand a category and view its subcategories, click on the arrow icon to left of the category.
To embed content within a Sub Category:
Navigate to the subcategory. To expand a category and view its subcategories, click on the arrow icon to left of the category.
Expand a category by selecting this icon Select the Category Details icon for the relevant Sub-Category within your Parent Category.
From within that Sub-Category, select New item, then follow steps 3-9 from the tutorial above.
Good to Know: Categories/Sub Categories will only be visible to the AD users/groups who've been assigned permission to view the Power BI content within them.
Dynamic Binding
The Reporting Hub supports what Microsoft calls dynamic binding, which allows you to select the semantic model (the dataset) your report is connected to. With dynamic binding, you can use one report to display different information, depending on the semantic model it's connected to. This can be useful if you have a standard report that you want to provide for different customers and a separate semantic model for each customer. Instead of copying and pasting the report visuals for each customer into their own report, you can re-use the same report and "bind" it to different datasets.
Learn more about dynamic binding:
Requirements for Dynamic Binding
The datasets that you select need to have the same schema -- the same columns, measures, and tables.
The report and dataset can be in different workspaces, but the workspaces must be assigned to a capacity.
The Reporting Hub must have access to the workspaces where the dataset(s) reside and to the workspace where the report resides.
Use Dynamic Binding
Turn on the Enable Dynamic Binding toggle when adding the report to your Reporting Hub and you can select the report workspace and the dataset workspace individually. See step 6 of the tutorial above for screenshots.
Direct Querying a Semantic Model/Multi-Dataset
If your report's semantic model has a Direct Query connection to another semantic model, you must enable dynamic binding and add both semantic models as datasets in the Reporting Hub. This situation commonly arises when your report uses multiple semantic models, or an existing semantic model and another data source.
For example, 'My Report' below is bound to 'Dataset B', which contains a connection to 'Dataset A'.
To add 'My Report' to the Reporting Hub, Dynamic Binding is enabled for the content page and both Dataset A and Dataset B are added as datasets.
Last updated