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.
DAX
6 articles
1 min read
Row-Level Security in Fabric: Data Access at the Row Level
RLS provides essential data security for multi-tenant and sensitive data scenarios. Tomorrow, I will cover Azure OpenAI function calling patterns.
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.
1 min read
Tabular Editor for Power BI: Advanced Dataset Development
dax\n{m.Expression}\n Tabular Editor transforms Power BI development: Faster editing for large models Automation capabilities Better governance through BPA…
6 min read
Power BI Smart Narratives vs DAX Text: Choosing How Reports Talk
When the Power BI smart narrative visual is enough, when a hand-written DAX text measure is safer, and the limitations that decide it before you publish.
1 min read
Power BI Row-Level Security: Data Access Control
In Desktop: Modeling → View as Roles → Select role → Enter email to test RLS enables true multi-tenancy in Power BI, where one dataset serves many users…