Power BI integration with power apps For Power BI visualization

Power BI is one of the best tools with easy and immersive Power BI visualization to provide insights. You must allow Power BI visualization from the Power Apps Portal’s admin center to view dashboards and reports from Power BI on web pages in a portal. By allowing the Power BI Embedded service integration, you can also insert dashboards and reports generated in the new Power BI workspace,Further info go through Power BI Course

Note

• You must have a suitable license for Power BI.
• You must have an acceptable Power BI Embedded License to use the Power BI Embedded service. See Licensing for more information.
• Ensure the content embedded in apps in your Power BI tenant Developer settings is activated. The portal can’t make an embedded Power BI dashboard or report when disabled.

Activate Power BI visualization for Power BI

Enabling Power BI visualization allows you to use the Powerbi Liquid tag to insert dashboards and web page reports into a portal.

Admin hub of Open Power Applications Portals.

Go to Configure Power BI Integration > Allow Power BI visualization for Power BI.

In the confirmation message, select Activate. The portal restarts when Power BI visualization is activated. Then it will be inaccessible for a few minutes. When Power BI visualization is activated, a message appears.

The Powerbi Liquid tag can be used by customizers to embed Power BI dashboards and web page reports in a portal. Customizers may use filter parameters to construct personalized views while embedding the Power BI material. For more details: power Liquid tag

Disable Power BI visualization of Power BI

Admin hub of Open Power Applications Portals.

Go to Configure Power BI Integration > Disable Power BI visualization of Power BI.

In the confirmation message, click Disable. The portal restarts while the Power BI visualization is disabled and will be inaccessible for a few minutes. When Power BI Power BI visualization is disabled, a message appears.

Enable Embedded service for Power BI

Enabling the Power BI Embedded service allows you to embed dashboards and reports generated in the new Power BI workspace. By using the power Liquid tag, the dashboards and reports are embedded in a portal on web pages.

Prerequisites:

Make sure that you have generated your dashboards and reports in the new workspace in Power BI before activating the Power BI Embedded service. Provide admin access to the global administrator after developing the workspace, so that the workspaces are shown in the admin center of Power Apps Portals. See Build New Workspaces in Power BI for more detail on building new workspaces and adding links to them.

Note

• Ensure the Power BI visualization of Power BI is allowed to work with the power Liquid tag.
• To allow the embedded Power BI service:
• Admin hub of Open Power Applications Portals.
• Go to Configure Power BI Integration > Allow Embedded service for Power BI.

Enable Embedded service for Power BI

Pick and transfer the Power BI workspaces from which dashboards and reports need to be displayed in your portal to the Selected workspaces list in the Allow Power BI Embedded service integration window.

Pick workspaces with Power BI

Note

After you add workspaces to the Selected Workspaces list, after a few minutes, the databases and reports are made.

Click Activate.

The portal restarts when the Power BI Embedded service is activated and is inaccessible for a few minutes. When the Power BI Embedded service is activated, a message appears.

You now need to build a protection category and link it to your account with Power BI. See Build Protection Group and link it to the Power BI account for more detail.

Create and add a protection category to the Power BI Account

You must establish a security group in the Azure Active Directory after allowing Power BI Embedded Service Integration. Add a member to it, and then add a security group to the Power BI through the Power BI Admin Portal. This enables the dashboards and reports generated in new workspaces for Power BI to be displayed in the portal.

Note

To allow the Power BI Embedded service, you must sign in with the same Global Administrator Account you used.

Step 1:

Build a Community for Security

Sign in to the Azure portal using the directory’s Global Administrator account.

Select Azure Active Directory, Groups, and select the New Group option.

Enter the following information on the Community page:

Form of Group: Security.

Name of the group: Portal Power BI Service embedded.

Definition of the group: This security group is used for the integration of Portal and Power BI Embedded services.

Form of membership: Allocated.

Build Power BI Embedded service protection community.

Select Creating.

Step 2:

Introduce a Member of the Party

Prerequisite:

You must have the application ID of the portal with you before adding a member to the security community. The application ID of the portal is available on the Portal Information tab in the admin center of Power Apps Portals.

Sign in to the Azure portal using the directory’s Global Administrator account.

Choose Azure Active Directory, then choose Classes.

Scan the Portal Power BI Embedded Service Group from the Groups — All Groups tab, then pick it.

Search and pick a Power BI Embedded service security community

Select Members from the Manage region on the Portal Power BI Embedded service Overview tab.

Select Add members, and in the text box, enter the application ID of the portal.

From the search results, pick a participant, and then choose Select.

Add a member of the Power BI Embedded Service Security Community to

Step 3:

The configuration of Power BI

Sign in to Power BI using the directory’s Global administrator account.

In the upper-right corner of the Power BI service, pick Settings and select Admin Portal.

In Power BI Operation, pick Admin Portal

Select Tenant Configurations.

Search for and pick the Portal Power BI Embedded service group in the Unique Security Groups sector.

Add a protection category to your Power BI Admin Server portal

Choose Apply.

Customizers can now embed Power BI dashboards and reports from new Power BI workspaces on web pages in a portal using the power Liquid name. An authentication form must be defined as power bi embedded to use the Power BI Embedded service. Customizers may use filter parameters to construct personalized views while embedding the Power BI material. Further details: power Liquid tag.

Manage the operation of Power BI Embedded

Admin hub of Open Power Applications Portals.

Go to Configure Power BI Integration > Power BI Embedded Service Management.

Manage Embedded service Power BI Visualization

Delete or switch the Power BI workspaces from which dashboards and reports need to be displayed in your portal to the Selected Workspaces list in the Manage Power BI Embedded service integration window.

Pick Power BI workspaces — Control integration of the Power BI Embedded service

Note

After you delete workspaces from the Selected Workspaces list, it can take up to 1 hour for changes to be reflected. The databases and reports are made on the portal without any problems until then.

• Check Save.
• Disable the Embedded service of Power BI
• Admin hub of Open Power Applications Portals.
• Go to Configure Power BI Integration > Power BI Embedded Service Management.
• Manage Embedded service Power BI
• In the Manage Power BI Embedded service integration pane, click Disable Power BI Embedded service integration.
• Disable Embedded service Power BI
• Check Save.

In the confirmation message, click OK. While the Power BI Embedded service is disabled, the portal restarts for a few minutes and is inaccessible. When the Power BI Embedded service is disabled, a message appears.

Power BI Embedded limitations of operation

Live connections from Azure Analysis Services do not help Power Apps portals. In import mode, you can use Analysis Services with row-level protection (RLS) applied instead of Analysis Services in the study.

Relating to privacy in Power BI visualization

When a user embeds a Power BI tile or dashboard, by allowing the embedding of Power BI tiles and dashboards, the user’s Azure Active Directory authorization token for Microsoft Dataverse is used to authenticate with an implicit grant from the Power BI service, providing the end-user with a seamless ‘single-sign-on’ experience.

Conclusion

To avoid using the Dynamics 365 authorization token for Power BI service authentication, an administrator can disable the embedding of Power BI tiles and dashboards at any time. For the end-user, any existing tiles or dashboards will avoid rendering. You can learn more about integration through Power BI online training.