New ways to optimize shared datasets in the Power BI Service

on YouTube ↗49m

" summary

A demo shows a concrete workflow that finds and removes unused columns and measures from a shared Power BI dataset, using Measure Killer locally (PBIX + downloaded reports) and Tabular Editor 3 via the XMLA endpoint to edit M code online. The analysis checks visuals, conditional formatting and filters, reports a surprising 50% unused (941 MB → 427 MB in the demo), supports restore/backups and Excel export, and finishes with a dataset the tool marks 100% used while noting fringe limitations like copied pages and table-count edge cases.

AI-written summary · about

" chapters (11)

1. 0:00Shared datasets in Power BI
2. 3:21Optimizing shared datasets
3. 7:21Live demo: shared dataset model
4. 10:08Analyzing unused elements
5. 22:39Cleaning measures and columns
6. 27:39Removing unused Power Query columns
7. 32:13Saving optimized model
8. 40:24Online optimization without Desktop
9. 44:45Tabular Editor cleanup
10. 47:16Finalizing results
11. 49:02Q&A

" related talks

• 18mEmpowering Business Through DataDeepthi Anantharam · Great Indian Developer Summit 2015
• 51mPower BI Composite and Hybrid ModelsAlex Whittles · SQLBits 2023
• 45mRebooting your SME Data Analysis StrategyMark Hayes · SQLBits 2020
• 54mExtending PowerPivot into a Scalable Component for Enterprise BIAvi Perez · PASS Business Analytics Conference 2013
• 02h 12mOptimizing your Power Pivot models using Power QueryKen Puls · PASS Business Analytics Conference 2015
• 54mData Visualization with Power View and the Tabular ModelJen Stirrup · PASS Business Analytics Conference 2013
• 48mDon't be scared with Hybrid, they are only tables…Bruno Mairos, Maria Gabriel · SQLBits 2023
• 01h 04mBest Practices for Collecting and Analyzing Data with Power Query and ExcelChris Webb · PASS Business Analytics Conference 2015