> For the complete documentation index, see [llms.txt](https://docs.thereportinghub.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.thereportinghub.com/getting-started/deployment-step-by-step/enable-power-bi-service-settings.md).

# Enable Power BI Service Settings

Give the Reporting Hub permission to access Power BI

For Reporting Hub (an Entra ID app) to access Power BI content and APIs, a **Fabric or Power BI Admin** needs to enable a set of tenant admin settings and then configure each workspace you want to use.

This page has two parts:

1. [**Enable Power BI tenant admin settings**](#enable-power-bi-tenant-settings)**:** turn on the settings Reporting Hub needs.
2. [**Configure your Power BI workspaces**](#power-bi-workspace-configuration)**:** make each workspace available to Reporting Hub.

## Enable Power BI Tenant Settings

Reporting Hub needs the following tenant settings enabled:

* [x] Allow XMLA endpoints and Analyze in Excel with on-premises datasets
* [x] Embed content in apps
* [x] Allow Service principals can create workspaces, connections, and deployment pipelines 
* [x] Allow Service principals can call Fabric public APIs
* [x] Allow service principals to create and use profiles
* [x] Enable Enhance admin APIs responses with detailed metadata
* [x] Grant Permission to workspaces

All of these are in the Power BI [**Admin portal**](https://app.powerbi.com/admin-portal/tenantSettings) under **Tenant settings**.

{% hint style="info" %}
**This applies to every setting below.** You can enable each toggle for your **entire organization** or for a **specific security group**. If you choose a specific security group, you must add the Reporting Hub Service Principal security group you created in **step 8** of the installation process.
{% endhint %}

### 1. Integration Settings

**1.A. Allow XMLA endpoints and Analyze in Excel with on-premises datasets**

* In the [**Admin portal**](https://app.powerbi.com/admin-portal/tenantSettings)**,** go to **Tenant settings**
* Scroll to **Integration settings**
* Enable the **Allow XMLA endpoints and Analyze in Excel with on-premises datasets.** ([Microsoft reference](https://learn.microsoft.com/en-us/power-bi/enterprise/service-premium-connect-tools#security))

<div align="center"><figure><img src="https://2452209205-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fd5bUZ5n4bSLHFrpgX6Nj%2Fuploads%2Ft6mMxRMXb5GoEsU71WBV%2Fintegration%20settings.png?alt=media&amp;token=e695575c-86bb-48c8-94a6-f9b3837d8508" alt="" width="361"><figcaption><p>This is usually enabled by default.</p></figcaption></figure></div>

{% hint style="warning" %}
**Note:** If you choose 'specific security group', you must add the Reporting Hub Service Principal security group you created in step 8 of the installation process.
{% endhint %}

### 2. Developer Settings

**2.A. Embed content in apps**

* Scroll to **Developer Settings**
* Enable **Embed content in apps**.

{% hint style="info" %}
**Note:** If you choose 'specific security group', you must add the Reporting Hub Service Principal security group you created in step 7 of the installation process.
{% endhint %}

<figure><img src="https://2452209205-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fd5bUZ5n4bSLHFrpgX6Nj%2Fuploads%2FmSI2yA8rSmtubRutP9NY%2Fimage.png?alt=media&amp;token=4ee6bb29-43af-4a5d-8f78-403ddd3dd699" alt="" width="375"><figcaption><p>This is usually enabled by default.</p></figcaption></figure>

**2.B. Service principals can create workspaces, connections, and deployment pipelines**

* Scroll down to **Developer Settings**&#x20;
* Enable the **Service principals can create workspaces, connections, and deployment pipelines**.

{% hint style="info" %}
**Note:** If you choose 'specific security group', you must add the Reporting Hub Service Principal security group you created in step 8 of the installation process.
{% endhint %}

<figure><img src="https://2452209205-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fd5bUZ5n4bSLHFrpgX6Nj%2Fuploads%2FV9ppevYMvGLPbXxGz9Es%2Fimage.png?alt=media&amp;token=cc6283e6-be34-4c9f-997b-45ec2b43c1d0" alt="" width="350"><figcaption></figcaption></figure>

**2.C. Service principals can call Fabric public APIs**

* Scroll down to **Developer Settings**&#x20;
* Enable the **Service principals can call Fabric public APIs.**

{% hint style="info" %}
**Note:** If you choose 'specific security group', you must add the Reporting Hub Service Principal security group you created in step 8 of the installation process.
{% endhint %}

<figure><img src="https://2452209205-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fd5bUZ5n4bSLHFrpgX6Nj%2Fuploads%2FqEZWMJZjZQmDLssoDeJ4%2Fimage.png?alt=media&amp;token=a119367b-9d40-473f-ad04-f267ebcbe7a6" alt="" width="324"><figcaption></figcaption></figure>

**2.D. Allow service principals to create and use profiles**&#x20;

* Scroll down to **Developer Settings**
* Enable the **Allow service principals to create and use profiles.**

{% hint style="info" %}
**Note:** If you choose 'specific security group', you must add the Reporting Hub Service Principal security group you created in step 7 of the installation process.
{% endhint %}

<figure><img src="https://2452209205-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fd5bUZ5n4bSLHFrpgX6Nj%2Fuploads%2Fj5yT0AtBO0p6wni5E9cE%2Fimage.png?alt=media&amp;token=0e367f56-b6c8-478b-b4b6-0785d06be3d2" alt="" width="254"><figcaption></figcaption></figure>

### **3. Admin API Settings**

**3.A. Enable Enhance admin APIs responses with detailed metadata**&#x20;

* Scroll down to **Admin API Settings**
* Enable the **Enhance admin APIs responses with detailed metadata.**&#x20;

To learn more about the Admin API Settings, visit this [Microsoft reference.](https://learn.microsoft.com/en-us/fabric/admin/service-admin-portal-admin-api-settings#enhance-admin-apis-responses-with-detailed-metadata)

{% hint style="info" %}
**Note:** If you choose 'specific security group', you must add the Reporting Hub Service Principal security group you created in step 7 of the installation process.
{% endhint %}

<div align="center"><figure><img src="https://2452209205-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fd5bUZ5n4bSLHFrpgX6Nj%2Fuploads%2FyiXzIquJEMJCEFm6SqWL%2Fadmin%20api%20settings.png?alt=media&amp;token=520f801c-69d2-4bed-8817-96eea94ada3f" alt="" width="361"><figcaption></figcaption></figure></div>

## Power BI Workspace Configuration

For each workspace you want to use in Reporting Hub, complete three steps:

* [x] [Assign your workspace to your fabric or embedded capacity](#assign-your-workspace-to-your-embedded-capacity)
* [x] [Add the Reporting Hub application to your workspace](#add-the-reporting-hub-application-to-your-workspace)
* [x] [Add the workspace to your Reporting Hub Global Tenant](#add-the-workspace-to-a-reporting-hub-tenant)

{% hint style="warning" %}
**Please note:** your personal '*My Workspace*' can not be added to the Reporting Hub.
{% endhint %}

### 1. Assign your workspace to your Embedded or Fabric Capacity

To add a Power BI workspace to a capacity, you'll need to:

1. Log in to: <https://app.powerbi.com>
2. Open the workspace you want to integrate with Reporting Hub. If this is your first time, we recommend starting with a **non-production** workspace.
3. Select **Workspace Settings**.

<figure><img src="https://2452209205-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fd5bUZ5n4bSLHFrpgX6Nj%2Fuploads%2Frn5DWBiUEvTmSAnSopfF%2Fimage.png?alt=media&amp;token=8a96d08b-61d9-43e2-9c64-80677a243854" alt=""><figcaption></figcaption></figure>

4. Select the **Workspace Type** tab
5. Select **Edit.**
6. Select the license mode **Embedded** *or* **Fabric**.&#x20;
7. If you have more than one embedded capacity, select the one that is being managed by Reporting Hub.
8. Click **Apply**.

{% hint style="warning" %}
**If capacity is greyed out:** The capacity selection will only be visible to you if you are a [**Capacity administrator**](https://learn.microsoft.com/en-us/fabric/admin/capacity-settings?tabs=fabric-capacity#add-and-remove-admins) and the [**capacity is currently active**](https://learn.microsoft.com/en-us/fabric/enterprise/pause-resume#resume-your-capacity). If the capacity is paused, you can start it by either going to the Azure portal and starting the capacity or by signing into Reporting Hub, and the application will start the capacity automatically.
{% endhint %}

<img src="https://2452209205-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fd5bUZ5n4bSLHFrpgX6Nj%2Fuploads%2FvvZGXM2BEWs4f5y57oSh%2FScreenshot%202026-08-25%20133056.png?alt=media&amp;token=33e68566-17d9-47dc-acb6-fb18fcac3763" alt="Note that it will say License Info instead of Premium" width="375">

### 2. Add the Reporting Hub Application to your Workspace

After assigning the capacity as the workspace license, you need to give your Reporting Hub application access to the workspace.

1. In your Reporting Hub application, navigate to **App Settings** > **App Information.**&#x20;
2. Copy the **Name** of your service principal and note the **Client ID.**

<figure><img src="https://2452209205-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fd5bUZ5n4bSLHFrpgX6Nj%2Fuploads%2F41KBIgGlXOK8hAbRT2Cq%2Fimage.png?alt=media&amp;token=e0c2f83e-bf77-43b3-bcc3-c20841e8fb1c" alt=""><figcaption></figcaption></figure>

3. Navigate back to the workspace in the [Power BI Service](https://app.powerbi.com). Ensure this is the same one from first step.
4. Select **Manage Access**&#x20;

![](https://2452209205-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fd5bUZ5n4bSLHFrpgX6Nj%2Fuploads%2FwNB0BoCtWStXzGS4LBgW%2FScreenshot%202026-08-25%20133311.png?alt=media\&token=e6ca95f4-ed6f-4d9b-8192-99a28b28d444)

5. Select **+ Add people or groups**.

![](https://2452209205-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fd5bUZ5n4bSLHFrpgX6Nj%2Fuploads%2FsUYXkpTO3v9TbxS2SLB2%2FScreenshot%202026-08-25%20133421.png?alt=media\&token=211c7ba5-f67f-4c1d-b01a-1ea04efe21ed)

5. In the 'Enter name or email' field, type the **Name** that you copied from your application&#x20;
6. Select the one that shows an **AppID** under the name.&#x20;
   1. If you see multiple apps with the same name, select the one with the **AppID** that matches the **Client ID** in your app.
7. Set the permission to **Admin.**&#x20;
8. Click **Add.**

<img src="https://2452209205-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fd5bUZ5n4bSLHFrpgX6Nj%2Fuploads%2FpOxo0hw2yFYVx1t88PCR%2FaddSP.png?alt=media&amp;token=31b571db-0c5f-4f99-8eec-0eda2c4dac0e" alt="" width="375">

{% hint style="info" %}
By using the application, workspaces are typically available in the Reporting Hub within minutes. If you choose the security group instead of the application, workspaces will take longer (hours or even next day) to become available in the Reporting Hub application.
{% endhint %}

{% hint style="danger" %}
**Service principal not showing up?** Ensure you have enabled your [Power BI Tenant settings](#enable-power-bi-tenant-admin-settings) and that your [Service principals can call Fabric public APIs](#id-2.c.-allow-service-principals-can-call-fabric-public-apis) setting is either enabled for the entire organization or that the application service principal you want to add is a member of one of the specified groups.

Sometimes copying and pasting adds an invisible character and the name may not appear. Try to type the name in, and you should see it in the list.
{% endhint %}

## Next:  Configure Reporting Hub App Settings

Now that the workspace is on your capacity and your Reporting Hub application has permission, assign the workspace to your Reporting Hub Global Tenant. We cover this in the next step.

{% content-ref url="/pages/D6QLOw6IhUgl69x7qJL6" %}
[Configure Reporting Hub App Settings](/getting-started/deployment-step-by-step/configure-reporting-hub-app-settings.md)
{% endcontent-ref %}


---

# Agent Instructions
This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com.

## Querying This Documentation
If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter, and the optional `goal` query parameter:

```
GET https://docs.thereportinghub.com/getting-started/deployment-step-by-step/enable-power-bi-service-settings.md?ask=<question>&goal=<endgoal>
```

`ask` is the immediate question: it should be specific, self-contained, and written in natural language.
`goal` is optional and describes the broader end goal you are ultimately trying to accomplish on behalf of the user. GitBook uses it to tailor the answer towards what is most useful for that goal.

The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.