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.
- Create a new Power BI user for this use case (optional but recommended)*
- Register an Azure AD application*
- Set your Azure App API Permissions*
- Create a Power BI Workspace (if there isn’t one already)
- Publish a Power BI Report
- Get the embedding parameter values
- 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
- Open the Power BI App Registration Tool (https://app.powerbi.com/embedsetup)
- In the Choose an embedding solution section, select Embed for your organization
- 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.
- 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
- Select Register
- Your Azure AD app Application IDand Application secret values are displayed in the Summary box. Copy these values for Step 6.
- 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.
- 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:
- Log into Microsoft Azure.
- Search for App registrations and select the App registrations
- 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.
- Under Manage, select API permissions.
- Under Configured Permissions, select Add a permission.
- In the Request API permissions pop-up window, select the Power BI Service API.
- 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
- Power BI Service
- Select Add permissions to save your changes.
- A Read permission should have been added already, make sure to not remove this permission. Your permissions should look like this now:
- 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
- This is the Application ID you copied in Step 1.
- If you lost the ID or forgot to copy it, follow the following steps:
- Log into Microsoft Azure.
- Search for App registrations and select the App registrations
- Select the Azure AD app your using for embedding your Power BI content.
- From the Overview section, copy the Application (client) ID
Client Secret
- This is the Application Secret you copied in Step 1.
- If you lost the Secret or forgot to copy it, follow the following steps:
- Log into Microsoft Azure.
- Search for App registrations and select the App registrations
- Select the Azure AD app your using for embedding your Power BI content.
- Under Manage, select Certificates & secrets.
- Under Client secrets, select New client secret.
- 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.
- 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.
- Create a new template and add the Power BI widget
- Open the widget parameters and enter all the information gathered in Step 6.
- Save the template and add it to a playlist.
Enjoy your embedded content!