---
id: semantic-link-functions-holidays
version: "0.14.2"
license: MIT License
license_treatment: permissive
maintenance: active
---

# semantic-link-functions-holidays — Semantic link functions for holidays package. Enables enrichment of FabricDataFrame with public holidays.

License: permissive · Maintenance: active · Downloads: 473.1K/mo

## What it is and what it does

This package extends FabricDataFrame with semantic functions that intelligently expose holiday-checking capabilities. It uses the @semantic_function decorator to automatically discover functions and makes them available in autocomplete only when your data contains the columns they need—in this case, a datetime column and a country column. The is_holiday function leverages the holidays library to determine whether dates fall on public holidays for a given country.

It's built for Power BI and Fabric workflows where data enrichment with domain-specific logic improves the interactive experience. Rather than manually calling holiday functions, developers annotate their logic once and the framework handles visibility and relevance based on the actual schema and metadata of each FabricDataFrame.

Use it for:

- Flag public holidays in a datetime column to exclude them from business-day calculations in Fabric reports.
- Enrich sales or transaction data with holiday indicators to segment analysis by holiday vs. non-holiday periods.
- Automatically surface holiday-checking logic in Fabric notebooks when working with date and country columns.
- Build data quality checks that validate whether expected holidays are correctly marked in a dataset.
- Create semantic layers in Power BI that expose country-specific holiday logic to end users without code.

## Worth the install?

AI-flagged interpretation of the facts above — verify before relying.

Adds semantic functions to FabricDataFrame that automatically detect and expose holiday-checking operations based on the presence of datetime and country columns in your data.

Yes, if you work with FabricDataFrame in Microsoft Fabric and need to add holiday logic to datetime columns. The low install friction, active maintenance, and permissive MIT license make it a straightforward addition. No known vulnerabilities. Install only if you're already using semantic-link-sempy; it's a specialized extension, not a general-purpose library.

## Install

pip install semantic-link-functions-holidays
uv add semantic-link-functions-holidays
poetry add semantic-link-functions-holidays

## Installing semantic-link-functions-holidays

Before you install: Active maintenance with a recent release (24 days old). Low install friction; depends only on holidays and semantic-link-sempy. Requires Python 3.10 or later.

License in practice: MIT License permits commercial and private use with minimal restrictions; you must include a copy of the license and copyright notice.

Quickstart:

pip install semantic-link-functions-holidays

from sempy.fabric import FabricDataFrame

df = FabricDataFrame(
    {"country": ["US", "AT"], "date": ["2023-01-06", "2023-01-06"]},
    column_metadata={"country": {"data_category": "Country"}},
)

holiday_series = df.is_holiday(date_col="date", country_col="country")

Requires Python 3.10 or later; designed for use with semantic-link-sempy.

Verify before relying:

- Whether the package works outside Microsoft Fabric or requires Fabric-specific infrastructure.
- Performance characteristics when applied to large DataFrames.
- Full list of supported countries beyond the US and AT examples shown.
- Whether datetime conversion is required before calling is_holiday or handled automatically.

## Package facts

- License: MIT License (permissive)
- Python support: supports_current
- Install friction: low
- Maintenance: active
- Downloads: 473.1K/month (top 15,000 on PyPI)
- Known vulnerabilities: none known

## Tags

holiday detection dataframe, semantic functions fabric, power bi holiday enrichment, datetime country holiday check, fabric dataframe extensions, semantic link holidays, automatic function discovery, fabric-integration, semantic-enrichment, holiday-data

[View on SkillFed](https://skillfed.io/packages/semantic-link-functions-holidays) · [View on PyPI](https://pypi.org/project/semantic-link-functions-holidays/)