Combine Power BI with External Tools
summary
Shows how to automate measure creation and debugging with Tabular Editor (runs scripts to generate display folders, create measures, and surface BPA rule violations), use ALM Toolkit to diff and merge two PBIX files (preserves unchanged objects, updates partitions and can deploy to the Service), and profile/query alternatives in DAX Studio where a rewritten measure drops from ~2600 ms to ~38 ms. Demonstrations include copying measures between files, resolving three reported errors, and successful deployments.
AI-written summary · about
chapters (9)
- 0:00Introduction and background
- 1:53Challenges in BI development
- 3:56Benefits of external tools
- 5:56Categories of external tools
- 9:01Using Tabular Editor
- 25:21BPA rules and automation
- 28:57ALM Toolkit for deployment
- 38:42Performance testing with DAX
- 46:05Additional tools and conclusion
related talks
22mTake off with Tabular Editor
01h 08mAdvanced Modelling and Calculation Using the Power BI Designer
51mTroubleshooting Power BI Report Performance
50mBuilding an Empire - Implementing Power BI Step by Step
47mFrom Power BI to Excel - The best of two worlds
38mCalculation Groups & C# - The Perfect Couple
50mLet End Users Drive: Empowering User Control in Power BI Reports
30mEmpower every BI professional to do more with Fabric