Home
Knowledge Base
Microsoft
SharePoint
How to view a full width Power BI report in SharePoint

How to view a full width Power BI report in SharePoint

Integrating Power BI and SharePoint is easy: Microsoft provides an out-of-the-box web part for SharePoint, and you just need to pull the report URL from Power BI.

While the process is simple, the report may be too small due to SharePoint’s maximum page width. In this article, you will find two different methods to embed a full-width Power BI Microsoft Power BI is an analysis platform. Data can be easily and safely analyzed and visualized here. Official Microsoft Power BI website mehr erfahren report in your SharePoint SharePoint is the intranet solution from Microsoft. SharePoint Online SharePoint online (SPO) is usually included in your Microsoft 365 subscription, but can also be purchased directly. SharePoint Online has the advantage that there is no need to operate a separate server, but it lacks the customization options of a self-hosted installation of SharePoint.Although SharePoint Online is limited to core functions... pages.

Create a full-width Power BI report with a single part app page

You can set up only one web part on single-part pages. You must use this method if you only want to display the report on the page and want to use all available space.

This process requires the use of PnP PowerShell. If you don’t have it installed yet, you can download it here and don’t worry I’ll provide all the necessary code.

To use this method, do the following:

1.Open your Power BI Microsoft Power BI is an analysis platform. Data can be easily and safely analyzed and visualized here. Official Microsoft Power BI website mehr erfahren report

2.Click Share -> Embed Report -> SharePoint SharePoint is the intranet solution from Microsoft. SharePoint Online SharePoint online (SPO) is usually included in your Microsoft 365 subscription, but can also be purchased directly. SharePoint Online has the advantage that there is no need to operate a separate server, but it lacks the customization options of a self-hosted installation of SharePoint.Although SharePoint Online is limited to core functions... Online

3.Copy the embed link

4.Open your SharePoint SharePoint is the intranet solution from Microsoft. SharePoint Online SharePoint online (SPO) is usually included in your Microsoft 365 subscription, but can also be purchased directly. SharePoint Online has the advantage that there is no need to operate a separate server, but it lacks the customization options of a self-hosted installation of SharePoint.Although SharePoint Online is limited to core functions... site and create a new page to add your report

5.Adding the Power BI Microsoft Power BI is an analysis platform. Data can be easily and safely analyzed and visualized here. Official Microsoft Power BI website mehr erfahren web part

6.Paste the link and configure the settings in the web part properties panel

7.Save the page and publish it

8.Download the PowerShell script from here, open your PowerShell console and run it. Running the script is self-explanatory and it allows you to switch between the 3 page layouts in case you want to revert your page to the original page layout.

9.Enter the URLA Uniform Resource Locator identifies and locates a resource, for example a website, via the access method to be used and the location of the resource in computer networks. for the site collection and the name of the page.

10.Choose Page Layout 3 – Single Web Part Application Page, after a few seconds you will see a success message in the console.

11.Refresh your page and you will get a full width report on SharePoint SharePoint is the intranet solution from Microsoft. SharePoint Online SharePoint online (SPO) is usually included in your Microsoft 365 subscription, but can also be purchased directly. SharePoint Online has the advantage that there is no need to operate a separate server, but it lacks the customization options of a self-hosted installation of SharePoint.Although SharePoint Online is limited to core functions...

Create a full-width Power BI report using a script editor

If you want to combine your report with other web parts on the page, you must use the Script Editor web part available in the PnP repository.

Modern SharePoint SharePoint is the intranet solution from Microsoft. SharePoint Online SharePoint online (SPO) is usually included in your Microsoft 365 subscription, but can also be purchased directly. SharePoint Online has the advantage that there is no need to operate a separate server, but it lacks the customization options of a self-hosted installation of SharePoint.Although SharePoint Online is limited to core functions... pages allow you to create a full-width section at the top of your pages. Unfortunately, there are only a limited number of web parts that can be used in this area, and Power BI Microsoft Power BI is an analysis platform. Data can be easily and safely analyzed and visualized here. Official Microsoft Power BI website mehr erfahren is not one of them.

However, the custom script editor can be used in full width and can be used to display your report along with other web parts.

Before you actually start implementing this method, you must first install the Script Editor web part on your tenantThe client (English tenant ) is the highest level of regulatory authority in the IT system and represents a closed unit in the system in terms of data and organization. The client thus structures the use of the system. A Tenant needed. The tenant is the “rented room” in the Microsoft data center, which is identified by the tenant name... by doing the following:

1.Download the installation file from here. If you want to compile the project yourself, you can find the source code here

2.Open your app catalog and upload the sppkg file

3.Be sure to select Make this solution available to all locations in the organization.

4.Click Deploy

Now that you have your web part ready, it’s time to create your SharePoint SharePoint is the intranet solution from Microsoft. SharePoint Online SharePoint online (SPO) is usually included in your Microsoft 365 subscription, but can also be purchased directly. SharePoint Online has the advantage that there is no need to operate a separate server, but it lacks the customization options of a self-hosted installation of SharePoint.Although SharePoint Online is limited to core functions... page by doing the following:

1.Open your Power BI Microsoft Power BI is an analysis platform. Data can be easily and safely analyzed and visualized here. Official Microsoft Power BI website mehr erfahren report

2.Click Share -> Embed Report -> Website or Portal

3.Copy the iframe code as shown in the following image

4.Edit your SharePoint SharePoint is the intranet solution from Microsoft. SharePoint Online SharePoint online (SPO) is usually included in your Microsoft 365 subscription, but can also be purchased directly. SharePoint Online has the advantage that there is no need to operate a separate server, but it lacks the customization options of a self-hosted installation of SharePoint.Although SharePoint Online is limited to core functions... page

5.Create a full width section