Explicit Measures Podcast 484: Data Governance in the Age of Fabric IQ
Dec 11, 2025
Dive into the intriguing world of data governance with insights on Fabric IQ's potential role. Explore practical strategies for enhancing governance frameworks and the importance of workspace identity in avoiding credential issues. Discover the benefits of integrating automation and APIs into developer workflows. Delve into the impact of Excel drill-through features, and the balance between MDX and DAX. The conversation wraps with governance guidelines, the challenges of educating users on AI tools, and a deep look into ontology and its relevance for effective data management.
AI Snips
Chapters
Transcript
Episode notes
Use Workspace Identity For Connections
- Use workspace identities (service principals) instead of user accounts to connect Fabric artifacts to data sources.
- This prevents broken connections when people leave and avoids shared-password service accounts.
Shared Service Accounts Hurt Security
- Mike described teams using shared "service" user accounts that require shared passwords and break MFA patterns.
- He prefers workspace identities because they avoid password sharing and brittle user-based connections.
Excel Gains Direct Drill-Through
- Excel now supports drill-through for DirectQuery and DirectLake models, bridging Excel and Power BI detail workflows.
- This may imply semantic model or client changes that affect MDX/DAX handling between Excel and Fabric.