Try ShortPoint nowPower BI is a powerful Microsoft service that allows users to turn large volumes of data into meaningful reports and visualizations. ShortPoint recognizes the value of presenting dashboards and reports on your SharePoint sites.
We have made it seamless to integrate Power BI output through the Power BI Design Element. We give you an overview of this feature in this article.
TABLE OF CONTENTS
Prerequisites
To integrate Power BI dashboards and reports using ShortPoint, you will need the following:
- You have the latest ShortPoint SPFx version installed on your SharePoint environment.
- You are a ShortPoint Designer with an active license.
- You have an active and Power BI License that enables you to share your reports.
- The users who will view your reports also have the appropriate Power BI licenses and/or permissions.
Overview of Power BI integration options using ShortPoint
The Power BI Integration options using ShortPoint are highly dependent on the type of Power BI license you have. We provide detailed steps on how to integrate Power BI reports in the following support articles. Check out the option that applies to you and your organization:
Still determining which option will work for you? Continue reading this article to learn more about the differences between these two options.
Differences between the two integration options?
You must select the appropriate integration option that fits the Power BI license that you have. Here are the main differences between the two options:
Option 1: User-based License Integration
 | Choose this option if you have a user-based license (Power BI Pro or Premium Per User). Visitors to your site must log in with their Power BI Pro or Premium Per User accounts to view your report. Please note that each logged-in session is limited to one hour. Users must re-enter their credentials to continue viewing the Power BI report. To get started with this option, continue to Power BI Integration Option 1: User-based License Integration article. |
Option 2: Capacity-based License Integration
 | Choose this option if your organization has a capacity-based license (Power BI Embedded) and you have a Pro or Premium Per User license that allows you to share dashboards and reports. Any visitor with permission to view your site will be able to view your report. To get started with this option, continue to Power BI Integration Option 2: Capacity-based License Integration article. |
Note: ShortPoint Power BI Design Element does not support the multi-factor authentication for capacity-based license integration. If such MFA is enabled, Power BI reports will not be visible on the SharePoint page.
This is a current limitation from Microsoft. Find more information about it here: Embed a report web part in SharePoint Online. Multi-factor authentication.
Integration requirements and user experience
There are distinct requirements to integrate Power BI reports between the two options. There is also a difference in the site visitor experience when viewing the reports on the page.
*In the case of Microsoft 365, if the logged-in user has been assigned Power BI pro license, and she/he has access to view the report, it will load the report without asking for login. However, if it's a Power BI Dashboard or Tile, it will ask the user to log in even if the logged-in user has rights to it.
**Users will be requested to log in with their Power BI credentials if ShortPoint cannot authenticate them automatically. We recommend adding a help message to give them tips on how to login and which account to use to view the report.
To learn more about the differences in Power BI capabilities, features, and pricing between the license types, you can check out the Power BI pricing details page.
Related articles:
