> ## Documentation Index
> Fetch the complete documentation index at: https://absentify.com/docs/llms.txt
> Use this file to discover all available pages before exploring further.

# Power BI custom connector

> Connect absentify to Microsoft Power BI with the custom connector to build dashboards, analyze absence trends, and report on leave data across teams.

With the **absentify Power BI custom connector**, you can seamlessly analyze absence data, identify trends, and optimize workforce planning. This tool is ideal for IT administrators and business users who need to connect absence data with reporting platforms like Power BI.

<Info>
  The custom connector is available exclusively on the Plus plan. To unlock this feature, explore our [Plans and pricing](https://absentify.com/pricing).
</Info>

### What is the Power BI custom connector?

The custom connector allows your organization to:

* Pull absence data directly from absentify into Power BI for advanced reporting.

* Streamline analytics workflows by eliminating manual data imports.

* Enable deeper insights by combining absence data with other organizational metrics.

### Key features

* **Direct API access**: Retrieve real-time absence data without complex configurations.

* **Custom dashboards**: Build tailored dashboards for HR, finance, or team managers.

* **Data export flexibility**: Integrate absence data with other tools and processes via Power BI.

### Setting up the custom connector

Follow these steps to install and configure the absentify Power BI custom connector:

<Steps>
  <Step title="Download the custom connector">
    1. Download the `.mez` file: [Download link](https://braincoresolutions-my.sharepoint.com/:u:/g/personal/marc_absentify_com/EdDqVoc9DF5CiCpJmhId-MAB9zt4YHFbElMrkYkEBCmy9Q?e=HqqaRt).

    2. Save the file in the `Documents\Power BI Desktop\Custom Connectors` folder. Create this folder if it doesn’t exist.
  </Step>

  <Step title="Enable custom connectors in Power BI">
    1. Open [Power BI Desktop](https://app.powerbi.com/home?experience=power-bi).

    2. Go to **File** > **Options and settings** > **Options**.

    3. In the menu, select **Security**.

    4. Under **Data Extensions**, select **Allow any extension to load without validation or warning**.

    5. Select **OK** and restart Power BI Desktop.
  </Step>

  <Step title="Generate an API key in absentify">
    1. Sign in to [absentify](https://app.absentify.com).

    2. Navigate to **Integrations** > **API Key**.

    3. Create and save your API key. Keep this key secure; you’ll need it in the next step.
  </Step>

  <Step title="Connect absentify to Power BI">
    1. In Power BI Desktop, go to **Home** > **Get Data**.

    2. Select **Other** > **absentify**.

    3. Select **Connect** and enter your API key when prompted.

    4. Start accessing your absence data directly within Power BI.
  </Step>
</Steps>

### Example use cases for M365 admins

* **HR dashboards**: Visualize absence trends, identify high absence rates, and plan workforce requirements.

* **Cross-department analytics**: Combine absence data with metrics from ERP or finance systems for comprehensive insights.

* **Scheduled reporting**: Automate monthly absence reports for leadership teams, combining multiple data sources.

<Tip>
  If your organization requires automation for data refreshes, consider using direct API requests via Power Query as described below.
</Tip>

### Automating data refreshes with Power Query

Scheduled refreshes are not supported by the custom connector in Power BI Service. To automate data updates, use direct API requests in Power Query — these **do** support scheduled refresh in the Service.

<Info>
  For more information on available endpoints and query parameters, visit our [API reference documentation](/docs/en/api-reference/introduction).
</Info>

#### Example: fetching members data

```m theme={null}
let
    apiKey = "your_api_key_here",
    response = try Web.Contents(
        "https://api.absentify.com",
        [
            RelativePath = "api/v1/members",
            Headers = [#"X-API-KEY" = apiKey]
        ]
    ),
    jsonResponse = if response[HasError] then error "Error: " & response[Error][Message] else Json.Document(response[Value]),
    responseTable = Table.FromList(jsonResponse, Splitter.SplitByNothing(), null, null, ExtraValues.Error),
    expandedTable = Table.ExpandRecordColumn(responseTable, "Column1", Record.FieldNames(responseTable{0}))
in
    expandedTable
```

<Note>
  **Enabling scheduled refresh in the Power BI Service:** keep `https://api.absentify.com` as the static base URL with the endpoint path in `RelativePath` (as above) — a fully dynamic URL works in Desktop but fails on the Service. After publishing, open **Dataset → Settings → Data source credentials** and set the authentication method for `https://api.absentify.com` to **Anonymous** (the API key travels in the `X-API-KEY` header). Do **not** pick OAuth2, Basic, or Organizational account — those fail with `DMTS_OAuthFailedToGetResourceIdError`.
</Note>

***

By leveraging the Power BI custom connector, M365 admins can empower their organization with actionable insights and streamline reporting processes. For additional assistance, visit our [support page](/docs/en/introduction#how-to-get-further-assistance).

***