# Power BI

{% hint style="info" %}
This integration is currently in beta.
{% endhint %}

This integration allows you to connect Halo Security to Power BI Desktop so you can query, visualize, and analyze your security data alongside other business data.

{% hint style="warning" %}
**Requirements:** This integration requires a Windows machine with [Power BI Desktop](https://powerbi.microsoft.com/desktop) installed.
{% endhint %}

### Create Integration in Halo Security

1. In the Halo Security dashboard, visit your *Settings → Integrations →* [Add](https://app.halosecurity.com/user/settings/integrations/add)
2. Add the **Power BI** integration
3. Enter a name for the integration and click **Save**
4. Copy the **API Key** and store it somewhere secure
5. Click **Download HaloSecurity\_PowerBI.mez**
6. Move the downloaded `.mez` file to the following location on your Windows computer: `C:\Users\<YourUsername>\Documents\Power BI Desktop\Custom Connectors`

{% hint style="info" %}
If the `Custom Connectors` folder does not exist, you will need to create it manually.
{% endhint %}

### Connect Power BI

1. Open **Power BI Desktop**
2. Go to **File** → **Options and settings** → **Options**
3. Navigate to the **Security** tab
4. Under **Data Extensions**, select **(Not Recommended) Allow any extension to load without validation or warning**
5. Click **OK**
6. Click **Get data** (or **Get data from another source**)
7. In the search box, type `Halo`
8. Select **Halo Security Connector (Beta) (Custom)**
9. Click **Connect**
10. Enter the API Key you copied when setting up the integration

{% hint style="info" %}
Power BI may prompt you to enter the API key twice during the connection process.
{% 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.halosecurity.com/docs/integrations/workflow-integrations/powerbi.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.