Power BI Integration

This integration copies Parquet files from the Haltian IoT Data API S3 bucket into Microsoft Azure and connects them to Power BI for analytics and dashboards. The infrastructure is fully automated with Terraform.

Overview

Haltian IoT sensors collect workplace data — occupancy, environment, movement — and export it as Parquet files via the Data API. This integration brings that data into Microsoft Power BI so your team can build dashboards, reports, and analytics without any custom development.

What it does

An automated pipeline copies sensor data from Haltian’s cloud into your Azure environment on a configurable schedule (default: every 15 minutes). Power BI connects directly to the data for real-time dashboards.

Setup at a glance

Architecture

A timer-triggered Azure Function App copies new Parquet files from S3 on a configurable schedule. You choose one of two Azure destinations.

%%{init: {'theme': 'base', 'themeVariables': {'primaryColor': '#F6FAFA', 'primaryTextColor': '#143633', 'primaryBorderColor': '#143633', 'lineColor': '#143633', 'secondaryColor': '#C7FDE6', 'tertiaryColor': '#73F9C1', 'clusterBkg': '#ffffff', 'clusterBorder': '#143633', 'edgeLabelBackground': '#ffffff'}}}%%
flowchart TB
    subgraph South["Haltian IoT"]
        S3["fa:fa-database S3 Bucket<br/>Parquet Files"]
    end

    subgraph Middle["Customer Azure"]
        FUNC["fa:fa-cogs Azure Function App<br/>Python · Timer Trigger"]

        subgraph Dest["Destination (choose one)"]
            ONELAKE["fa:fa-layer-group Microsoft Fabric<br/>OneLake Lakehouse"]
            STORAGE["fa:fa-hdd Azure Storage Account<br/>Blob Storage"]
        end
    end

    subgraph North["Analytics"]
        PBI["fa:fa-chart-bar Power BI<br/>Dashboards & Reports"]
    end

    S3 -->|"List & Get Objects"| FUNC
    FUNC -->|"DFS API"| ONELAKE
    FUNC -->|"Blob Service"| STORAGE
    ONELAKE --> PBI
    STORAGE --> PBI

Destination Options

See Microsoft Fabric pricing and Azure Storage pricing for current costs.

Source Files

All Terraform modules and the Azure Function source code are available as downloadable files. Each deployment guide below includes a download table with direct links to every file:

Prerequisites

• Terraform ≥ 1.5.0 — install guide
• Azure CLI (az) — installed and authenticated (az login)
• Azure subscription with Contributor permissions
• S3 credentials from Haltian (access key + secret, or bring-your-own IAM role)
• Python 3.10+ (optional, for local Function App development)

Additional prerequisites depend on your chosen destination — see the deployment guides below.

Deployment Guides

Follow these guides in order to deploy the complete integration:

S3 Access Credentials

Haltian provides two options for S3 bucket access:

Data Flow

Once deployed, the Azure Function runs on a configurable schedule (default: every 15 minutes):

1. List Objects — queries S3 for Parquet files within the configured time range
2. Download — retrieves each file from S3
3. Authenticate — uses MSAL client credentials (OneLake) or connection string (Storage Account)
4. Upload — writes to OneLake via DFS API or to Blob Storage
5. Log — records activity in Application Insights

Reference

• Configuration Reference — all Terraform variables across modules
• Troubleshooting — common issues and solutions