Power BI Integration

1. Open the Azure Portal
2. In the search bar, search for App registrations. Open it and start a new registration by clicking New registration
3. On the Register an application page, enter the following details:
   • Name: Honeydew Power BI Integration
   • Supported account types: Accounts in this organizational directory only (Single tenant)
   • Redirect URI: Leave blank
4. Click Register
5. On the homepage of your newly created application, from the Overview screen, copy the values for the following fields and store them in a secure location:
   • Application (client) ID
   • Directory (tenant) ID
6. From the left menu of your newly created application page, open Manage > Certificates & secrets
7. Click New client secret
8. In the Add a client secret dialog, enter the following details:
   • Description: Honeydew Power BI Integration
   • Expires: Choose an appropriate expiry date
9. Click Add
10. Copy the value of the newly created client secret and store it in a secure location

1. Open the Azure Portal
2. In the search bar, search for Microsoft Entra ID and select it from the drop-down list
3. In the left menu, expand the Manage section, and click Groups
4. At the top of the page, click New group and enter the following details:
   • Group type: Security
   • Group name: Honeydew Power BI Integration
   • Membership type: Assigned
   • Under Members, click No members selected, in the Add members dialog that opens up search for the application you created in the previous step (e.g. Honeydew Power BI Integration) and click Select to add it.
5. Click Create to create the group

1. Open the Microsoft Power BI Service Homepage
2. Click on Workspaces in the left menu bar
3. Click on the workspace you want to add Honeydew access to (repeat these steps for each workspace)
4. In the top bar, on the right, click Manage Access
5. Click Add people or groups and search for the security group you created in the previous step (e.g. Honeydew Power BI Integration)
6. In the role drop-down, choose Member as the role
7. Click Add to add the group

To enable the Microsoft Power BI admin API:

1. Log in to the Power BI Admin Portal
2. In the left menu under Admin Portal, click Tenant settings
3. Under the Developer settings heading, click to expand Service principals can use Fabric APIs and ensure it is Enabled
   • Under Specific security groups (Recommended), add the security group created above (e.g. Honeydew Power BI Integration)
   • At the bottom of the expanded section, click the Apply button
4. Under the Admin API settings heading, configure the following:
   • Click to expand the Service principals can access read-only admin APIs expandable and ensure it is Enabled
     • Under Specific security groups, add the security group created above (e.g. Honeydew Power BI Integration)
     • At the bottom of the expanded section, click the Apply button
   • Click to expand the Enhance admin APIs responses with detailed metadata expandable and ensure it is Enabled
     • Under Specific security groups, add the security group created above (e.g. Honeydew Power BI Integration)
     • At the bottom of the expanded section, click the Apply button
   • Click to expand the Enhance admin APIs responses with DAX and mashup expressions expandable and ensure it is Enabled
     • Under Specific security groups, add the security group created above (e.g. Honeydew Power BI Integration)
     • At the bottom of the expanded section, click the Apply button

1. Open the Microsoft Power BI Service Homepage
2. In upper right corner click the gear icon for Settings and then click on Manage connections and gateways
3. In the Connections tab, identify the connection used for Honeydew (note that it should have a Gateway cluster name configured).
4. Click on the three dots next to the right of the connection name, and then click Manage users in the popup menu.
5. In the Manage users dialog, search for the security group created above. Provide the group with the User permission and click Share.

1. In Honeydew, go to the Settings page
2. Click on Power BI in the left menu
3. Fill in the following fields:
   • Application ID: The Application (client) ID from the Entra ID App you created
   • Tenant ID: The Directory (tenant) ID from the Entra ID App you created
   • Client Secret: The client secret from the Entra ID App you created
4. Click Save