Only an admin can set up the PowerBI integration.
Getting Started with Power BI
Integrate Power BI with Soal using two methods:
- OAuth with Soal’s managed Power BI Azure Enterprise Application (OAuth)
- Create and manage a Power BI Azure Enterprise Application (Azure AD App)
- Utilize Admin APIs
- Utilize Non-Admin APIs
OAuth
Soal’s Power BI integration utilizes OAuth 2.0 to connect to your Power BI workspace. Here’s how to establish the connection:
- Navigate to
Integrations
on the sidebar, click New integration
and choose Power BI
.
- Go to the
OAuth
tab.
- Click
Connect with OAuth
. This action redirects you to a login page requesting permissions for your Power BI workspace.
- After successful OAuth authentication, click the
Run Initial Sync
button.
Azure AD App
Follow these steps to set up Power BI Integration via Azure AD App:
Step 1: Create an Azure AD App
- Open the Azure portal.
- Search for
App registrations
and click + New registration
.
- Fill in the form with the following details:
- Name: Soal
- Supported account types: Accounts in this organizational directory only (Default Directory only - Single tenant)
- Redirect URI (optional): Leave blank
- Click
Register
.
- Post submission, copy and save the
Application ID
(Client ID) and Tenant ID
from the Overview tab.
- Click
Certificates & secrets
tab, then New client secret
.
- Enter a description, specify the expiration for the client secret, and click
Add
.
- Copy and save the
Client secret value
.
Step 2.1: (Only for non-admin API)
- Navigate to
API permissions
tab, click Add a permission
to add necessary permissions.
Step 2.2: (Only for admin API)
- Re-open the Azure portal.
- Search and select
Azure Active Directory
link.
- Click
Groups
tab, then New group
.
- Complete the form with the following:
- Group type: Security
- Group name: PowerBI API Access
- Group description: (Optional)
- Click
Create
.
Step 2.3: (Only for admin API) Enable Power BI service admin settings
- Sign in to the Power BI admin portal.
- Ensure
Tenant settings
tab is open.
- Under
Developer settings
, find and open the subsection “Allow service principals to use Power BI APIs”. Select Enabled
and add the security group PowerBI API Access
created earlier.
- Repeat the above for all subsections in “Admin API settings”, enabling and adding the security group.
Step 3: Add Azure AD app to your workspace
- Sign in to Power BI.
- Search and select the workspace, then from the
More
menu, choose Workspace access
.
- Search for Soal as a member, select the entry.
- Choose
Viewer
or Contributor
for Permission.
- Click
Add
and then Close
.
Step 4: Connect PowerBI API to Soal
- Go to
Integrations
in the sidebar, click New integration
and select Power BI
.
- Fill in the details from Step 1:
- Client ID: Application ID of Azure AD.
- Tenant ID: Identifier of tenant of organization in Azure Active AD.
- Client Secret: Client secret of the Azure AD App.
- Click
Connect
.
note:
- Non-admin API doesn’t support extracting tables, columns, and measures from PowerBI datasets (except for push datasets).
- You need PowerBI Admin privileges to successfully complete the OAuth flow.
Responses are generated using AI and may contain mistakes.