tom-operations

Manage semantic models in Microsoft Fabric and Azure Analysis Services using the Tabular Object Model wrapper in Python.

561|190|Updated May 16, 2024
One-click install
npx skills add https://github.com/microsoft/semantic-link-labs --skill tom-operations
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: tom-operations
Source: https://github.com/microsoft/semantic-link-labs/tree/main/.claude/skills/tom-operations
Command: npx skills add https://github.com/microsoft/semantic-link-labs --skill tom-operations

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes scripts (resource) and references (resource) components.

What problem does it solve?

This Skill simplifies the complex task of programmatically modifying and managing semantic models in Microsoft Fabric, saving data professionals significant time and effort.

Core Features & Use Cases

  • Metadata Manipulation: Read, update, and add tables, columns, measures, and relationships within semantic models.
  • Automated Model Management: Streamline repetitive tasks like updating measure descriptions or adding new calculated columns.
  • Use Case: Automatically update the descriptions and format strings for all measures in a semantic model after a schema change, ensuring consistency and clarity.

Quick Start

Use the tom-operations skill to connect to the 'My Semantic Model' dataset in 'My Workspace' and update the description for the 'Revenue' measure in the 'Sales' table.

Frequently Asked Questions about tom-operations

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I programmatically modify semantic models in Microsoft Fabric?

You can programmatically modify semantic models in Microsoft Fabric using a Python Tabular Object Model (TOM) wrapper. It allows you to read, update, and add metadata such as tables, columns, measures, and relationships directly.

What is the best way to automate updating measure descriptions across an Analysis Services model?

Automating measure description updates across an Analysis Services model is achieved by connecting via the Python TOM wrapper. This streamlines repetitive metadata management tasks like updating format strings or adding calculated columns.

Can I use service principal authentication to access Azure Analysis Services metadata?

Yes, you can use service principal authentication to access Azure Analysis Services metadata. The TOM wrapper supports both read-only and read-write access modes for securely managing your semantic models.

Does the Python Tabular Object Model support adding new relationships to semantic models?

Yes, the Python Tabular Object Model fully supports adding new relationships to semantic models. It facilitates comprehensive metadata manipulation, allowing you to read, modify, and add tables, columns, and measures.

How do I connect to a specific dataset and update a measure in a semantic model?

To update a measure in a semantic model, connect to the target dataset within your workspace using the Python TOM wrapper. You can then locate the specific measure and programmatically apply the required description or format string updates.