Pushing Your Power BI Potential: A Comprehensive Health Check for Improved Performance and Security
summary
Walks through concrete checks and tools: run VertiPaq Analyzer (via DAX Studio) to find oversized columns and cut model size, run Tabular Editor best practice analyzer to flag modeling anti patterns, verify 1 GB dataset and 8 refreshes limits under Pro vs when to move to Premium/PPU, test Azure Conditional Access (MFA for third parties) and Row Level Security with a multi‑tenant example (store manager sees only UK stores), measure dataset:report ratio to spot duplicated datasets and quantify reuse savings.
AI-written summary · about
chapters (12)
- 0:00Introduction and speakers
- 1:26Why Power BI health checks
- 3:55Performance optimization basics
- 5:19Model analysis with DAX Studio
- 7:04Security features overview
- 8:09Conditional access in Power BI
- 8:51Row-level security explained
- 9:57Data governance importance
- 10:59Dataset-to-report ratio analysis
- 13:05Centralized governance approach
- 14:31Best practice analyzer demo
- 15:59Licensing and cost considerations
related talks
52mAvoiding Turbulent Skies: Power BI Security Strategies for a Smooth Flight
43mKeeping up with your Power BI Tenant Administration
21mWhat you can do to protect your SQL Server and why it matters
44mFlight Plan for Data Security: Safeguarding your Dataset with Dynamic Object-Level Security
41mAutomating Power BI Governance: How dynamic security groups can solve 95% of your sharing needs
31mBuilding Big Data Platforms: the Hidden Security Flaws You Need to Be Aware Of- 21mWhat you can do to protect your SQL Server and why it matters
45mSecure and govern Copilot within enterprise-grade low code solutions