RECOMMENDATION: If you are using a version of The Portal Connector higher than 4.0, we strongly recommend utilizing the MVC based widgets and components to create your site. This documentation is for legacy purposes only and will soon be deprecated.

Configuring Power BI Reports

A Power BI Report is a multi-perspective view into a dataset, with visualisations that represent different findings and insights from that dataset. The report is highly interactive and highly customisation and the visualisations update as the underlying data changes.

How to configure Power BI Reports

Drag and drop the Power BI Report widget to your page. Click on the edit button to open the widget designer.

PBI-Reports

 There are two types of reports that can be embedded using Power BI Report widget.

  1. Power BI Embedded Reports
  2. Power BI Reports

 Select the type of the report that needs to be displayed on the page.

PBI-Reports-11 


Based on the selection provide related details to configure them.

Configure Power BI Embedded Reports

In order to configure Power BI Embedded Report, first create Workspace Collection in the Portal Connector.
  1. Navigate to the Sitefinity backend
  2. Open Administration > Settings > Advanced.
  3. PortalConnectorMvc > PowerBI > Workspace Collections.
  4. Click on Create new. Provide the work space collection name and Access key details.
PBI-Reports-3

To know the Workspace Collection Name and Access key details, login to Power BI Embedded for the details.
Select the ‘Overview’ tab to view the Workspace Collection Name.


PBI-Reports-4

Click on ‘Access key’ under the general section, to view the keys.

PBI-Reports-5

There will be two keys available, you may choose any one key.



Enter the Work space Collection details in Power BI Report widget designer and click Save.

PBI-Reports-6

Configure Power BI Reports

In order to configure Power BI Reports, you will need the report URL. Login to Power BI and access Reports under My Workspace tab.

PBI-Reports-7

On a report in your workspace that you can edit, select File > Publish to web.

PBI-Reports-8

A dialog appears that provides a link that can be sent in email, embedded in code (such as an iFrame).

PBI-Reports-9

Copy and paste link in the Embed URL field on the widget designer. Click Save.

PBI-Reports-10

Now you will have you page display Power BI reports .