Skill UI

This comprehensive guide details the programmatic management of semantic model refreshes using the Power BI Enhanced Refresh REST API and Fabric CLI. It covers the entire refresh lifecycle, including resolving model IDs, validating baseline data, triggering various refresh types (full, data-only, calculate), monitoring status, and performing robust post-refresh validation. Essential for automating ETL and data pipeline processes in a modern data platform.

This skill scrapes Substack Notes analytics by extracting key engagement metrics (likes, comments, restacks) and content details. It overcomes the lack of a public API, allowing users to analyze performance data from a specified date range into a highly formatted, actionable Excel spreadsheet. The output includes detailed per-note data, total engagement calculations, and summary statistics.

Run arbitrary PySpark or pure Python code directly on Fabric Spark compute using the Livy API. These sessions are ephemeral, meaning no notebook artifacts are created or persisted, making it ideal for automated ETL processes, programmatic data transformations, or agent-driven compute workflows. Provides full read/write access to lakehouse Delta tables via Spark SQL.