Setting up the PowerBI App Tile

As part of Simpplr's app tiles feature, we offer several out-of-the-box app tiles your org can set up on home and site dashboards. The article linked below gives an overview of how app tiles work, permissions around setting them up, and various requirements. 

Setting Up Out-of-the-Box App Tiles on Dashboards

This article explains the PowerBI tile.

The PowerBI integration is built on the Bring Your Own Integration (BYOI) framework, offering the following key benefits to customers:

1. Extensibility beyond pre-built use cases – In addition to the existing pre-built app tiles, customers can extend these integrations by building custom API actions and custom app tiles tailored to their specific needs.
2. Bring-Your-Own-App support – For OAuth-based apps, scopes and permissions can be controlled at the connector level. However, for user-level connections, data access remains restricted to the permissions individual users hold within the external apps, ensuring flexibility and security.

PowerBI tile

Allow user to embed a report from PowerBI

This tile allows users to embed PowerBI report. The report must reside within a named workspace. The users/user groups who are part (as a admin/member) of the same workspace in PowerBI will have the permission to view the report.

It displays:

• PowerBI report
• External Link to PowerBI report page

Inputs:

• Workspace ID (required)
• Report ID (required)

Prerequisites & Setup:

• OAuth Configuration – An OAuth app must be set up within Microsoft Entra Account by the admin.
• Register an app in Microsoft Entra ID or add the permissions to the existing app if applicable, add these permissions to the registered app.
  Note: Account type can be of Single tenant or Multitenant
  
• Obtain the Client ID from the Overview tab
• In the authentication tab add the callback URL:
  Use this if in the US: https://integration.app.simpplr.com/connector/callback
  Use this if in EU: https://integration.eu.simpplr.com/connector/callback
• Generate or obtain the secret from the Certificates & secrets tab, make sure to copy the Value of the secret

Add the following permissions in the API permissions tab:

• Select Microsoft Graph from the list and select
  - offline_access, openid, User.Read
• Again go back and choose PowerBI Service
  - Report.Execute.All
  - Report.Read.All
  - Dataset.Read.All
  - Workspace.Read.All

• Navigate to Manage > Application > Integrations > Custom apps > Add new app > Add prebuilt app, then select and add the PowerBI app.
• While adding, configure the OAuth details, including:
  • Client ID
  • Secret Key
  • Auth URL: https://login.microsoftonline.com/{account_type}/oauth2/v2.0/authorize?response_type=code&scope=openid+offline_access+https://analysis.windows.net/powerbi/api/.default [scopes : scope=openid, offline_access, https://analysis.windows.net/powerbi/api/.default]
  • Token URL: https://login.microsoftonline.com/{account_type}/oauth2/v2.0/token
  • Base URL: https://api.powerbi.com/v1.0/myorg

By default: account_type is `common` i.e. set for multitenant account, if the app is registered as a single tenant you need to enter the Directory (tenant) ID present in the overview tab in the {account_type} placeholder.

• After completing the configuration, enable the app.
• Once enabled, the app will be available under the Add Tile option on the home or site dashboard.
• Users must authenticate using their PowerBI/Fabric account.
• To add the tile, user needs to paste the entire link of the report as seen in the address bar while viewing the report from its workspace. The link on the address bar typically looks like https://app.powerbi.com/groups/{{workspace_uuid}}/reports/{{report-uuid}}. 
• The users/user groups who are part (as a admin/member) of the same workspace in PowerBI has the permission to embed the report within the dashboard.