Force Fabric FAQs

Question 1

What is Force Fabric?

Accepted Answer

Force Fabric is a powerful MCP server designed to scan, detect, and automatically fix issues across your entire Microsoft Fabric tenant. It helps optimize data items like Lakehouses, Warehouses, Eventhouses, and Semantic Models for improved performance, reliability, and data quality.

Question 2

What types of issues can Force Fabric detect and fix?

Accepted Answer

Force Fabric detects over 120 different issues, ranging from performance bottlenecks and schema inefficiencies to data quality problems and configuration errors. It can automatically resolve 45 of these issues using methods tailored to each Fabric item, such as SQL DDL, REST API, KQL commands, and Notebook-based operations.

Question 3

How does Force Fabric apply automated fixes safely?

Accepted Answer

Force Fabric employs multiple safe fix application methods. For Eventhouses, it supports a dry-run mode to preview KQL commands before execution. For Lakehouse and Semantic Model fixes requiring Spark SQL or `sempy`, it creates, runs, and deletes temporary Notebooks, ensuring minimal impact and clear audit trails.

Question 4

Which Microsoft Fabric data items does Force Fabric optimize?

Accepted Answer

Force Fabric offers comprehensive optimization across all core Microsoft Fabric data items: Lakehouses (including SQL Endpoints and OneLake Delta Logs), Warehouses, Eventhouses (KQL databases), and Semantic Models (Power BI datasets). It applies specific rules and fixes for each item type.

Question 5

Can I see the detected issues before applying fixes?

Accepted Answer

Yes, every scan performed by Force Fabric generates a unified, clear results table. This report highlights detected issues, warnings, and passed rules, along with actionable recommendations. This allows users to review and understand all findings before initiating any automated fixes.

Force Fabric

Force Fabric

主な機能

ユースケース

主な機能

ユースケース