Embed a PowerBI Report

Introduction

This article outlines the method to embed a Power BI report in your published Dataset.

Step 1: Creating a Dataset Table Record

1. Open the Dataset Page in Business Central.
2. Open the Dataset you want display the Report in.
3. Create a New Line, optionally you can assign a Table No.
4. Set the Type to Power BI

Info

When a Table No. is supplied, the first value in the Table is used for filtering the Report. This process can be more precise when a filter is applied within the filter configuration within the Dataset table.

Step 2: Filling the nessescary options

Get the Group ID

The groupId corresponds to the Workspace in Power BI. If you want to find it manually, you can do it via the Power BI Service. Here are the steps:

• Login to the Power BI Service: https://app.powerbi.com
• On the left-hand side, you'll see the "Workspaces" section. Click on the workspace for which you want to get the ID.
• Once inside the workspace, the URL in the browser's address bar will look something like: https://app.powerbi.com/groups/{workspace-id}/list
• The {workspace-id} part of the URL is your groupId.

Get the Report ID

The reportId corresponds to the Report in Power BI. If you want to find it manually, you can do it via the Power BI Service. Here are the steps:

• Login to the Power BI Service: https://app.powerbi.com
• On the left-hand side, you'll see the "Workspaces" section. Click on the workspace containing
• Now you'll should see a list of your reports, if configured. Click on the Report for which you want to get the ID.
• Once inside the Report, the URL in the browser's address bar will look something like: https://app.powerbi.com/groups/{workspace-id}/reports/{report-id}/{page-name}?experience=power-bi
• The {report-id} part of the URL is your reportId.

Info

At this point on, all nessescary configurations have been made and you can continue with the step Display on Dashboard. All following configuration is optional.

Get The Default Page

The Default Page is referring to the page names in Power BI. This option specifies wich Page is opened when DPS initializes the Report. You can aquire the Page Name as following:

• Login to the Power BI Service: https://app.powerbi.com
• On the left-hand side, you'll see the "Workspaces" section. Click on the workspace containing
• Now you'll should see a list of your reports, if configured. Click on the Report for which you want to get the Default Page Name.
• Once inside the Report, the URL in the browser's address bar will look something like: https://app.powerbi.com/groups/{workspace-id}/reports/{report-id}/{page-name}?experience=power-bi
• The {page-name} part of the URL is your page name ypu can use to set the default page.

Configure view mode

To open an embedded report in edit mode, use the viewMode property together with the permissions property.

You can assign the viewMode property the following values:

• View - Opens the report in view mode.
• Edit - Opens the report in edit mode.
• Create - Opens the report in Create mode(experimental feature).

Client-side filtering

By default, the filter pane is visible. If you want to hide this pane, use the PowerBI Filter activ property.

Navigation

By default, the navigation bar is visible. If you want to hide this bar, use the PowerBI Navigation activ property. Its highly recommended to use this feature together with default page, when wanting to only publishing a single page from a report.

Display on dashboard

To access the Report in the Portal, you have to configure the Dashboard to show the datasettable.

1. Open the Datasettable card of the dataset you have configured Power BI for.
2. Click on the Action Dashboard Groups select an existing line or create a new line.
3. Select the datasettable code of the Power BI report you have previosly configured.
4. Set the Element View Style to PowerBI

Display on head view

To access the Report in the Portal, you have to configure the Dashboard to show the datasettable.

1. Open the Datasettable card of the dataset you have configured Power BI for.
2. Click on the Action Dashboard Groups select an existing line or create a new line.
3. Select the datasettable code of the Power BI report you have previosly configured.
4. Set the Element View Style to Cue or Button.

Considerations & Limitations

• "My Workspace" or "me" is unsupported with service principal.
• Power BI admin rights are needed for enabling service principal in developer settings.
• Limitations exist in API support and dataflow management.
• Specific permissions are required for usage with Azure Analysis Services data source.