# PowerBI Semantic Layer

Connect Dot to your Power BI semantic models to query your measures and dimensions using natural language. Dot syncs your workspaces, datasets, measures, and columns—including their descriptions—so you can ask questions about your data without writing DAX.

{% hint style="info" %}
**Requirements**

* **Power BI Premium or Premium Per User (PPU)** capacity is required
* "Dataset Execute Queries REST API" must be enabled in your tenant settings
* You must have access to the workspaces you want to sync
  {% endhint %}

## Connect to Power BI

<figure><img src="https://3709841693-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FCeRlmJf2y704TpjpubE1%2Fuploads%2Fgit-blob-04ac3d1d011e1fc3736debf8edced5173a9f2bf7%2Fpowerbi-connector.png?alt=media" alt="Power BI connection settings"><figcaption></figcaption></figure>

1. Go to **Settings → Semantic Layers → Power BI**
2. (Optional) Enter a **Workspace ID** to sync only that workspace, or leave it empty to sync all workspaces you have access to
3. Click **Connect with Microsoft**
4. Sign in with your Microsoft account and grant access
5. Dot will start syncing your semantic models

{% hint style="success" %}
**Finding your Workspace ID**

Open your workspace in Power BI. The Workspace ID is in the URL: `https://app.powerbi.com/groups/{workspace-id}/...`
{% endhint %}

## What Gets Synced

When you connect Power BI, Dot imports:

* **Workspaces** — appear as schemas in Dot
* **Datasets / Semantic models** — appear as tables
* **Measures and columns** — with their descriptions and data types
* **Relationships** — connections between tables

Dot periodically re-syncs to pick up new or changed models. You can also trigger a manual sync from the connection settings.

## Limitations

{% hint style="warning" %}
**Known limitations**

* **Premium or PPU capacity required** — datasets on shared capacity cannot be queried via the API
* **Row-Level Security (RLS) not supported** — datasets with RLS enabled cannot be queried
* **Personal workspaces not supported** — "My Workspace" cannot be accessed via OAuth
* **Maximum 100,000 rows per query** — larger result sets are truncated
  {% endhint %}


---

# Agent Instructions: 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:

```
GET https://docs.getdot.ai/integrations/semantic-layers/powerbi-semantic-layer.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
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.