Power BI Widget

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
  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. 

 

Step 1 - Create a new Power BI user 

It is good practice to create a new user within Power BI. This user (it's credentials) will be used within GoBright View.

 

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- 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 IDand Application secret values 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:
    • Power BI Service
      • Read.All
      • ReadWrite.All
      • Read.All
      • ReadWrite.All
      • Read.All
        • Note: This permissions requires admin consent
      • ReadWrite.All
        • Note: This permissions requires admin consent
  1. Select Add permissions to save your changes.
  2. A Read permission should have been added already, make sure to not remove this permission. Your permissions should look like this now:

    powerbi.png
  3. You can now close this tab.

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

Create a workspace within Power BI.

Step 5 - Publish a Power BI Report

Publish a Power BI Report.

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 PowerBI and then copy the entire 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. Search for App registrations and select the App registrations
    3. Select the Azure AD app your using for embedding your Power BI content.
    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.
    7. From the Client secrets section, copy the string in the Value column of the newly created application secret. The client secret value is your client ID.

Step 7 - Set up the widget within GoBright View

Using the View Widget is very simple after the previous steps have been completed.

  1. Create a new template and add the Power BI widget 
  2. Open the widget parameters and enter all the information gathered in Step 6.
  3. Save the template and add it to a playlist.

Enjoy your embedded content!

 

0 out of 0 found this helpful