Using the Power BI Widget within GoBright View

This guide will explain which steps are needed in order to successfully use the View Power BI Embedding widget.

This is, in short, what this guide will help you accomplish.

  1. Create a new Power BI user for this use case (optional but recommended)*
  2. Register an Azure AD application*
  3. Set your Azure App API Permissions*
  4. Create a Power BI Workspace (if there isn’t one already)
  5. Publish a Power BI Report in said Workspace
  6. Get the embedding parameter values
  7. Set up the widget within GoBright View

*An Azure administrator needs to perform step 1, 2 and 3.
Please read this guide carefully and follow each step.

Supported devices

The Power BI Widget can be used on Windows, but should not be used in webOS devices. WebOS devices have a limited support for browser features (more information), therefore the Power BI widgets might stop working if Microsoft updates Power BI.

Step 1 - Create a new Power BI user

It is good practice to create a new user within Power BI, a service account if you will, specifically for this use case. This user will be used within GoBright View.

MFA (Multi Factor Authentication) must be disabled for this user.

Step 2 - Register an Azure AD application

  1. Open the Power BI App Registration Tool (https://app.powerbi.com/embedsetup)
  2. In the Choose an embedding solution section, select Embed for your organization
  3. In Step 1 – sign in to Power BI, sign in with a user that belongs to your Power BI tenant. The Azure AD app will be registered under this user.
  4. In Step 2 – Register your application, fill in the following fields:
    • Application Name– Give your application a name.
    • Home Page URL– Enter a URL for your home page.
    • Redirect URL– Upon signing in, your application users will be redirected to this address while your application receives an authentication code from Azure. Select one of these options:
      • Use a default URL (preferred) – This option will automatically create and download a sample embedded analytics application. The default URL is http://localhost:13526/.
      • Use a custom URL – Select this option if you already have an embedded analytics application, and know what you want to use as a redirect URL.
    • API access– Select these permissions:
      • Read all dashboards
      • Read all reports
  1. Select Register

    1. Your Azure AD app Application ID and Application Secret Value are displayed in the Summary box. Copy these values for Step 6.

  2. If you haven’t made a Power BI workspace yet, you can do it here. You can always do this later from the Power BI application.
  3. This windows or tab can now be closed.

For more information refer to the Microsoft docs.

Step 3 - Set your Azure App API permissions

After registering your Azure App, you need to setup the required API Permissions. You can easily do this by following these steps:

  1. Log into Microsoft Azure.
  2. Search for App registrations and select the App registrations
  3. Select the Azure AD app you’re using for embedding your Power BI content.
    • If the App does not show up, click on All applications, your application will show up there.
  4. Under Manage, select API permissions.
  5. Under Configured Permissions, select Add a permission.
  6. In the Request API permissions pop-up window, select the Power BI Service API.
  7. Select Delegated permissions and select the following permissions:powerbi.png
    Note: for Tenant.Read.All and Tenant.ReadWrite.All admin consent is required.
  1. When the permissions are set this tab can be closed.

Step 4 - Create a Power BI workspace (or use an existing one)

Create a workspace within Power BI.

This is mandatory, only reports within a workspace can be displayed within GoBright View

Step 5 - Publish a Power BI Report

Publish a Power BI Report. Make sure it’s within the workspace mentioned in the previous step.

Step 6 - Get the embedding parameter values

The following information is needed within GoBright View (the next and final step).

Username:

The username of the account (email address). Preferably the account created in step 1.

Password:

The password of the account.

URL

The entire url of the report you want to show.
To find this: open the report in Power BI and then copy the entire URL. The url should look something like this: https://app.powerbi.com/groups/[group-id]/reports/[report-id]/ReportSection

Note: If the URL contains /me/, the report is not within a Workspace (as mentioned in step 4) and the URL won’t work in View.
Place the report in a workspace to get the required URL.

Azure Client ID

  1. This is the Application ID you copied in Step 1.
  2. If you lost the ID or forgot to copy it, follow the following steps:
    1. Log into Microsoft Azure.
    2. Search for App registrations and select the App registrations
    3. Select the Azure AD app your using for embedding your Power BI content.
    4. From the Overview section, copy the Application (client) ID

Client Secret

  1. This is the Application Secret you copied in Step 1.
  2. If you lost the Secret or forgot to copy it, follow the following steps:
    1. Log into Microsoft Azure.
    2. In the search bar on top, type App registrations and select the App registrations
    3. Select the Azure AD app created earlier in Step 1
    4. Under Manage, select Certificates & secrets.
    5. Under Client secrets, select New client secret.
    6. In the Add a client secret pop-up window, provide a description for your application secret, select when the application secret expires, and select Add.
      Note this date in your calendar so you can renew this on time.
    7. From the Client secrets section, copy the string in the Client Secret Value column of the newly created application secret.

      The Client Secret Value always contains ~ (tildes).

Step 7 - Set up the widget within GoBright View

  1. Create a new template or slide and add the Power BI widget
  2. Open the widget parameters and enter all the information gathered
    Microsoft username: the email address of the account mentioned in Step 1
    Microsoft password: the password of the account mentioned in Step 1
    Azure Client ID: the Client ID of the created Azure App in Step 6
    Client Secret Value: the Secret Value of the created Azure App in Step 6, the one with the ~ (tildes)
    InputUrl: the entire URL from Step 6.
  3. Save the template and add it to a playlist.

Enjoy your embedded content!

Loading times

Reports can take quite a while to load, especially on slower hardware (webOS devices). Because of this we recommend to set the play time of a slide containing the Power BI widget to at least two minutes. Each time the widget plays, the entire report loads again.

Azure policies

If you’ve followed this guide and still no Power BI report is loading within the GoBright View Portal: Please check for any active policies in Azure which may block access.

This article comes from the Help Center of GoBright.

View original article

FAQ

Ask us anything! Find the answers to the most frequently asked questions here.

Browse the FAQs

Help Center

A goldmine for all IT and Facility Managers. Dive into the technical stuff concerning our products and solutions.

Visit the Help Center

Newsletter

Wanna stay informed of all developments within the smart office and our new features? Subscribe now.

Subscribe now