absentify Power BI Connector Documentation

Interested in analyzing data trends to optimize operations or efficiently handle employee absences? As an HR admin, this integration empowers you to unlock actionable insights from absence data and enhance operational decision-making.

With the Microsoft Power BI Connector offered by absentify, you can elevate how you analyze absence planning and internal scheduling.

​

Why use the Power BI Connector?

The Power BI Connector allows you to:

• Visualize absence trends to identify areas for improvement.
• Create dashboards tailored to your organization’s needs.
• Integrate absence data seamlessly into broader business intelligence workflows.

​

Quick Start Guide

​

Installing the Connector

1. Download the Custom Connector

   • Get the absentify Power BI Custom Connector (.mez) file here: Download Link

2. Save the File

   • Place the .mez file in the folder:

     Documents\Power BI Desktop\Custom Connectors
     

   • If this folder doesn’t exist, create it manually.

3. Enable Power BI Desktop to Use Custom Connectors

   • Open Power BI Desktop.
   • Navigate to File > Options and Settings > Options.
   • In the left menu, click Security.
   • Under Data Extensions, select:
     • Allow any extension to load without validation or warning.
   • Click OK and restart Power BI Desktop.

​

Configuring absentify for Integration

1. Generate an API Key

   • Log in to absentify.
   • Go to Settings > Integrations > API Key.
   • Generate a new API key and save it securely for later use.

2. Connect Power BI to absentify

   • In Power BI Desktop, go to Home > Get Data.
   • Scroll to Other and select absentify.
   • Enter the API key when prompted.

​

Using Direct API Requests

For automation and advanced queries, you can integrate Power BI directly with the absentify API using Power Query.

​

Example: Fetching Members Data

let
    apiUrl = "https://api.absentify.com/api/v1/members",
    apiKey = "your_api_key_here",
    headers = [ #"X-API-KEY" = apiKey ],
    response = Web.Contents(apiUrl, [ Headers = headers ]),
    jsonResponse = Json.Document(response),
    responseTable = Table.FromList(jsonResponse, Splitter.SplitByNothing(), null, null, ExtraValues.Error),
    expandedTable = Table.ExpandRecordColumn(responseTable, "Column1", {"id", "name", "email"})
in
    expandedTable

​

Example: Fetching Requests Per Day

let
    apiUrl = "https://api.absentify.com/api/v1/requests_per_day",
    apiKey = "your_api_key_here",
    queryParams = [
        start = "2024-01-01T00:00:00Z",
        end = "2024-01-31T23:59:59Z",
        status = "APPROVED"
    ],
    headers = [ #"X-API-KEY" = apiKey ],
    response = Web.Contents(apiUrl, [ Headers = headers, Query = queryParams ]),
    jsonResponse = Json.Document(response),
    responseTable = Table.FromList(jsonResponse, Splitter.SplitByNothing(), null, null, ExtraValues.Error)
in
    responseTable

​

Automating Data Refreshes

To automate data refreshes, consider using Power Query with direct API integration as described above. This bypasses the limitations of the Power BI Service.