Microsoft Power BI is a business intelligence tool that enables users to visualize, analyze, and derive insights from data through interactive dashboards and reports. This connector allows you to send data directly from our platform to Power BI for further analysis and display.
In this article
- Adding a Power BI Connection
- Configuring Power BI API Permissions
- Authorizing Connection
Adding a Power BI Connection
When logged into your DOWO Flow web portal, navigate to Connected Data > Connections > Add Connection - Power BI.
All the details necessary to configure your connector are available to you after you set up your app on the MS Azure portal by following the MS Graph guide.
| Property | Description | Obtained? |
| Application ID | This identifies your Power BI application to Azure Active Directory. This value will be a GUID in the form: 3c8ae5a6-4869-41a9-af36-8517434d9cc0 |
via Azure portal |
| Application Secret | This secures your Power BI application with Azure Active Directory. This value is NOT a GUID and will be in the form of: obH8P~yMaQYvxv-JZDKUIv.N9XVe3Kc_l8Z5OaYF |
via Azure portal |
| Workspace ID |
Add an ID for your custom PowerBI workspace. Leave blank to use the default My Workspace. |
obtained from Power BI Dashboard URL |
| Application Redirect URL (Redirect URI on Azure portal) |
https://secure-eu.DOWO Flow.com/oauth2/powerbicallback |
used in Azure portal, |
Once you've followed the setup guide, created your app, and set your API permissions, you'll be able to fill out all the fields associated with the Connection's properties and then hit SAVE to view the Authorize button.
Clicking the Authorize button will authorize the use of the currently signed-in Microsoft account. If you prefer to use a different account, you can either log out of all currently signed-in accounts and then click this button again or you can open an incognito, private browsing window to sign in with your preferred account.
Note: Azure AD is being renamed to Microsoft Entra ID.
Configuring Power BI API Permissions
By this point, your app should be configured on the Microsoft Azure portal, and now you just need guidance to add the correct permissions for Power BI to allow you to authenticate correctly.
After selecting "Power BI Service" as the service for which you would like to configure API permissions, on the next screen, select "Delegated Permissions" as shown in the screenshot below:
On the "Delegated Permissions" screen, you will need to add explicit support for the following API permissions for your Power BI connection to work.
| Power BI API Permission Requirements | ||
| API/Permission Name | Type | Description |
|
Dataset.Read.All |
Delegated | View all datasets. |
|
Dataset.ReadWrite.All |
Delegated | Read and write all datasets. |
| User.Read | Delegated | Sign in and read the user profile. |
Your permissions are setup correctly if they look like the permissions in the screenshot below:
If you've completed all of the above successfully, then you are finally ready to authorize your connection on our platform.
Authorizing Connection
On our secure web portal, after entering your Client ID and Secret, hit Save and then Authorize. If you've done everything correctly, then after you authorize our platform to connect to your account, you should see the success indicator below:
