> For the complete documentation index, see [llms.txt](https://docs.infotopics.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.infotopics.com/features/power-bi-extension/authentication/power-bi-sso-setup.md).

# Power BI SSO setup

With single sign-on, people never type a password into WriteBackExtreme: Power BI hands the visual a Microsoft Entra token for the person reading the report, and WriteBackExtreme exchanges it for a session. It is the smoothest option for your readers, and it is what [semantic model refreshing](https://docs.infotopics.com/features/power-bi-extension/integration/semantic-model-refreshing.md) needs.

Setting it up has two halves: allow the visual to ask for a token in Power BI, and tell WriteBackExtreme which tenant to accept tokens from.

## 1. Enable SSO for custom visuals

{% stepper %}
{% step %}

### Open the Power BI Admin Portal

<figure><img src="https://3247237607-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F0gkOLIfzuEyMP2kvoT9o%2Fuploads%2Fgit-blob-2e922ed29aecf44e514fef90db0c4e41ff52e350%2Fimage%20(10).png?alt=media" alt="" width="375"><figcaption></figcaption></figure>
{% endstep %}

{% step %}

### Go to Tenant settings

{% endstep %}

{% step %}

### Find AppSource Custom Visuals SSO and enable it for your organisation

<figure><img src="https://3247237607-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F0gkOLIfzuEyMP2kvoT9o%2Fuploads%2Fgit-blob-ff24f6b7cf944e311c135cc426cd9185e599b397%2Fimage%20(3).png?alt=media" alt=""><figcaption></figcaption></figure>
{% endstep %}
{% endstepper %}

Once it is on, people can request access to the **WriteBackExtreme Entra application registration**.

<figure><img src="https://3247237607-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F0gkOLIfzuEyMP2kvoT9o%2Fuploads%2Fgit-blob-baca882dc7e059c9b7b6cbf26dfd60643f595e3e%2Fimage%20(5).png?alt=media" alt=""><figcaption></figcaption></figure>

<figure><img src="https://3247237607-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F0gkOLIfzuEyMP2kvoT9o%2Fuploads%2Fgit-blob-4c89dfc5b838b2d26317f3dba86e98440868ffdf%2Fimage%20(6).png?alt=media" alt="" width="383"><figcaption></figcaption></figure>

### Grant admin consent

An administrator can grant it for the whole tenant at once with this URL:

```
https://login.microsoftonline.com/common/adminconsent?client_id=3896aab8-67bb-47d5-95c7-c873da280af8
```

## 2. Allow your tenant in the management console

Power BI will now offer a token; WriteBackExtreme still has to accept it. In the management console, open [Power BI authentication](https://docs.infotopics.com/features/management-console/setup-security/power-bi-auth.md) and fill in the card:

| Setting                                                       | What it does                                                                                           |
| ------------------------------------------------------------- | ------------------------------------------------------------------------------------------------------ |
| **Enable Power BI authentication**                            | Turns the whole thing on. Without it, sign-ins are refused with *Power BI authentication is disabled.* |
| **Allowed tenant ID**                                         | The Microsoft Entra tenant whose tokens are accepted. Tokens from any other tenant are rejected.       |
| **Automatically create users when missing on Power BI login** | Creates a WriteBackExtreme user the first time someone signs in, instead of refusing them.             |
| **Default groups for new Power BI users**                     | The groups those new users land in — and therefore the permissions they start with.                    |

Click **Apply config** to save.

{% hint style="warning" %}
Pick the default groups deliberately before you switch on automatic creation. Everyone in your tenant who opens the report becomes a WriteBackExtreme user with those groups' permissions.
{% endhint %}

Leave automatic creation off, and people who have no WriteBackExtreme account are turned away with *No local account exists for this user and automatic Power BI provisioning is disabled.* — which is the right choice when you want to hand out access by hand.

## What people see

Signing in happens by itself when the report opens, with the message **Attempting single sign-on with your Power BI account...**

| Message                                                                                    | What it means                                                                                                                                                |
| ------------------------------------------------------------------------------------------ | ------------------------------------------------------------------------------------------------------------------------------------------------------------ |
| **Power BI SSO authentication is not available in this environment.**                      | Power BI did not hand over a usable token. Check that the tenant setting above is on, and that consent has been granted to the WriteBackExtreme application. |
| **Power BI authentication is disabled.**                                                   | The management console setting is off.                                                                                                                       |
| **Missing Authorization bearer token.**                                                    | No token reached the server.                                                                                                                                 |
| **AAD token does not contain a valid e-mail.**                                             | The Entra account has no e-mail address for WriteBackExtreme to match on.                                                                                    |
| **No local account exists for this user and automatic Power BI provisioning is disabled.** | The person has no WriteBackExtreme user, and automatic creation is off.                                                                                      |

With SSO working you do not need the **User** data well. Keep [Username setup](https://docs.infotopics.com/features/power-bi-extension/authentication/username-setup.md) for the installations that authenticate another way.

Make sure your data updates are reflected in the report afterwards:\
[Semantic Model Refreshing](https://docs.infotopics.com/features/power-bi-extension/integration/semantic-model-refreshing.md)


---

# 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 by asking a question.

Perform an HTTP GET request on the following URL with the `ask` and `goal` query parameters:

```
GET https://docs.infotopics.com/features/power-bi-extension/authentication/power-bi-sso-setup.md?ask=<question>&goal=<user_goal>
```

`ask` is the immediate question: it should be specific, self-contained, and written in natural language.
`goal` is what the user is ultimately trying to achieve, the reason they need the answer. Sharing it helps GitBook give you a better, more relevant answer. A goal is most helpful when it describes the outcome the user wants rather than restating the question. For example, with `ask=how do I create an API token`, a goal like `automate deployments from our CI pipeline` lets GitBook tailor the answer to that use case.

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.
