8 min read
APPROXIMATEDISTINCTCOUNT in Direct Lake: When 1.6% Error Is Fine
APPROXIMATEDISTINCTCOUNT now runs on Import and Direct Lake models in preview. Decide per measure where about 1.6% error is fine, label it, and test the gain.
Semantic Models
6 articles
8 min read
Apache Ossie and the Portable Semantic Layer: What It Fixes and What It Doesn't
Microsoft backed Apache Ossie at FabCon with a Power BI converter. It makes metric names portable, not DAX semantics, security rules or performance.
9 min read
Fabric IQ Goes GA in Copilot: Your Semantic Model Is Now an Agent API
Fabric IQ is GA in Copilot Chat, Cowork and MCP. Treat each semantic model as an agent endpoint: RLS, OLS, metadata contracts and default-on access.
8 min read
Converting Direct Lake Tables to Import: Designing Hybrid Models
Power BI now converts single Direct Lake tables to Import in web modelling, making storage mode a per-table choice with real refresh and governance costs.
9 min read
Designing a Gold Layer and Semantic Model That Stay in Direct Lake
Design-time rules for Direct Lake in Fabric: size tables to your SKU's guardrails, move logic into Delta, avoid views, and control when models reframe.
1 min read
Semantic Models in Microsoft Fabric: Building the Analytics Layer
Semantic models provide the business logic layer that enables self-service analytics. Tomorrow, I will cover Fabric Notebooks.